[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..


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?

Last edited by jayjays on Sat Apr 24, 2010 1:55 am, edited 1 time in total.
Open Office 2,0, Windows XP
Posts: 9
Joined: Mon Apr 05, 2010 11:12 am

Re: Match formula

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


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
Posts: 918
Joined: Sun May 31, 2009 1:35 am
Location: Sydney, Australia

Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 19 guests