1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Jun 17, 2009 at 07:18 PM
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.
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.
Aug 15, 2012 at 02:57 PM