lookup text, return number

J

JenD

Hi. I'm trying to find a way to manage data. I have a worksheet of text
codes with corresponding numeric data ajacent to the code. I want to find a
way to lookup a specific code and return the number associated with it.
EX.
Jen 10
Bob 14
Jan 17

I want EXELL to search through this list for "BOB" and return the number 14.
Thanks
 
B

BenjieLop

If your codes are in Column A and the corresponding numeric codes are i
Column B, this formula (enter, say, in Cell D1) should work for you:

=vlookup(C1,$A$1:$B$100,2,0)

where:

C1 is where you enter the code that you want looked up
$A$1:$B$100 is the range of the table that contains your data
 
J

jeff

Hi,

Use the Vlookup function
e.g., if data in A1:B3, in C2 enter
=IF(C1="","",VLOOKUP(C1,A1:B3,2))

jeff
 
J

Jack Schitt

=VLOOKUP("Bob",A1:B100,2,0)
Where text codes are in A1:A100 and numerical data are in the column
directly to its right.

If the numerical codes are not conveniently placed relative to the text
codes then you can achieve the same result with INDEX and MATCH functions
(see help on them).

If the text codes are not unique then you may need something more
sophisticated.
 
Top