look up word

B

Big Rob

I am trying to input a word into one cell I want to auto generate the
contents of another cell based on the first input.
I can use Lookup if the first input is a number but this does not seem to
work if the first input is a work or alfa numeric.
 
B

Big Rob

I have tried VLOOKUP but this also does not allow me to use alfa numeric
inputs in the lookup cell, If I used a straight number it wooks fine
returning a work in the cell but not lookup a word and returning a different
word based on the first word.

Big Rob
 
G

Gary''s Student

Here is an example of looking up a text value. Say in A1 thru B17 we have:

Mimas 184
Enceladus 80
Tethys 182
Dione 5
Rhea 177
Titan 71
Hyperion 127
Iapetus 161
Erriapus 82
Phoebe 187
Janus 122
Epimetheus 117
Helene 7
Telesto 130
Calypso 199
Kiviuq 177
Atlas 54

The formula:

=VLOOKUP("Titan",A1:B17,2,FALSE) correctly returns 71
 
Top