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
User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives
[Solved] Match formula
2 posts
• Page 1 of 1
[Solved] Match formula
by jayjays » Sat Apr 24, 2010 1:30 am
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
by ken johnson » Sat Apr 24, 2010 1:36 am
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.
- ken johnson
- Volunteer
- Posts: 918
- Joined: Sun May 31, 2009 1:35 am
- Location: Sydney, Australia
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 10 guests
|
Forum powered by phpBB © phpBB Group
By any use of this Website, you agree to be bound by these Policies and Terms of Use |
Get OpenOffice
|