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
[Solved] Match formula
[Solved] Match formula
Last edited by jayjays on Sat Apr 24, 2010 1:55 am, edited 1 time in total.
Open Office 2,0, Windows XP
-
- Volunteer
- Posts: 918
- Joined: Sun May 31, 2009 1:35 am
- Location: Sydney, Australia
Re: Match formula
Try...
=INDEX($G$1:$G$197;MATCH(I34;$F$1:$F$197;0))
Ken Johnson
=INDEX($G$1:$G$197;MATCH(I34;$F$1:$F$197;0))
Ken Johnson
AOO 4.1.3 on Ms Windows 10
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.
Help improve this forum by clicking the EDIT button on your first post then adding "[Solved]" to its heading once a solution to your problem has been provided.