ASSOCIATE number TO VALUE

Z

zsozi

My problem is that i could't associate a numer to value
I have a column with numbers and every number is a person name
I don't have any ideea how can i do this whith functiom if does not
work. The function gives back one value.
Example:
If cell = 3 then replace with blabla
If cell 4 then replace with bleble
If cell 5 then replace with blublu
......
.....
etc.
Thank you.
 
T

Toppers

Create a table with number in column A and corresponding name in column B (as
an example) and use VLOOKUP

A B
3 blabla
4 bleble
5 blublu

Say in D1 put:

=VLOOKUP(C1,$A:$B,2,FALSE) where C1 contains your number

So if C1=3, D1 will contain "blabla"

HTH
 
R

Ragdyer

You need to make a datalist.

Say Column Y contains the numbers,
And Column Z contains the matching names.

Say this list went from Y1 to Z100.

Say your list of numbers to lookup is in Column A, from A1 down.

Enter this formula in B1, and copy down as needed:

=Vlookup(A1,$Y$1:$Z$100,2,0)
 
Top