Have a value in I34
I use..
=MATCH(I34;F1:F197)
to find what row the value in I34 is, (this case 145)
in G1:G197 i have a chart from which i want the formula to return my answer
F145 corresponds to G145 etc
what should i add to my formula to get the answer which is stated in G145?
jayjays