[Solved] Match formula

Discuss the spreadsheet application

[Solved] Match formula

Postby jayjays » Sat Apr 24, 2010 1:30 am

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
Last edited by jayjays on Sat Apr 24, 2010 1:55 am, edited 1 time in total.
Open Office 2,0, Windows XP
jayjays
 
Posts: 9
Joined: Mon Apr 05, 2010 11:12 am

Re: Match formula

Postby ken johnson » Sat Apr 24, 2010 1:36 am

Try...
=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.
ken johnson
Volunteer
 
Posts: 918
Joined: Sun May 31, 2009 1:35 am
Location: Sydney, Australia


Return to Calc

Who is online

Users browsing this forum: No registered users and 10 guests