Related:
- Both rows and columns lookup
- Display two columns in data validation list but return only one - Guide
- Https //accounts.google.com/sign in/v1/lookup - Guide
- Area code lookup - Guide
- Lookup computer name by ip - Guide
- Excel duplicate rows n times ✓ - Office Software Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
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