Both rows and columns lookup

Closed
mine - Jun 17, 2009 at 01:59 PM
 1234897k - Aug 15, 2012 at 02:57 PM
Hello,
Can anyone please help me on how to set up a formula for both rows and column lookup?

here's an example
Fruit Price1 Price2
Apples 0.69 0.65
Bananas 0.34 0.37
Lemons 0.55 0.54
Oranges 0.25 0.26

Example:
In my input tab, i have the folowing

Fruit : Lemons
Price: Price2
Result: (lookup formula that will give me 0.54)

Thanks!

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Jun 17, 2009 at 07:18 PM
put inA10 lemons
and B10 this formula

=VLOOKUP($A10,$A$1:$C$5,COLUMN($C$1),FALSE)

if you want prsice1 you change the thrid argument from 3 to 2.

assuming your data is in
a1 to c5 including column headaers.
0
this did not work
0