Excel : VLOOKUP

[ajw150]

Hi,

Need to very simple help, please.

I need to get relevant text to appear in a cell according to th
numeric value attached. ie A1 = 1 B1 = ABC, A2 = 2 B2 = DEF, etc, so i
C1 equaled 2, then the cell would lookup in the table above and kno
that therefore the applicable text is DEF.

Hope its clear, how can this be done. PS, there will be many man
options.

Thanks

Andre

 

[AlfD]

Hi!

Suppose Col A1:A100 contains the numbers and col B1:B100 contains th
text you want to find and that these columns have been sorted i
ascending order of the values in A.

Put in cell D1 =Vlookup(C1,A1:B100,2,False).

I'm not sure that this is quite what you asked for. My reading was tha
you would like to put the 2 in C1 and have the result appear also i
C1. If that is the case, I would resort to VBA.

Al

 

[JulieD]

Hi Andrew

if i'm following you correctly and you have the following table set up

A B
1 1 ABC
2 2 DEF

etc
and you want to type 2 in C1 and have the associated information appear in
D1, type in D1
=VLOOKUP(C1,$A$1:$B$1000,2,false)
where B1000 is the last of your "many many options"

hope this helps
Cheers
JulieD

 

[ajw150]

That works, many thank

 

[Frank Kabel]

Hi
in D1 try
=VLOOKUP(C1,A1:B20,2,0)