ASSOCIATE number TO VALUE
 

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.


--
zsozi
------------------------------------------------------------------------
zsozi's Profile: http://www.excelforum.com/member.php...o&userid=36931
View this thread: http://www.excelforum.com/showthread...hreadid=566429

ASSOCIATE number TO VALUE
 

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

"zsozi" wrote:


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.


--
zsozi
------------------------------------------------------------------------
zsozi's Profile: http://www.excelforum.com/member.php...o&userid=36931
View this thread: http://www.excelforum.com/showthread...hreadid=566429

ASSOCIATE number TO VALUE
 

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)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"zsozi" wrote in
message ...

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.


--
zsozi
------------------------------------------------------------------------
zsozi's Profile:
http://www.excelforum.com/member.php...o&userid=36931
View this thread: http://www.excelforum.com/showthread...hreadid=566429