Both rows and columns lookup [Closed]

Report
-
 1234897k -
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

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
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.
this did not work

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!