Formula Dilemna

[DrJekyll]

Gotta problem here! Simple as it is, I can't figure it out. I need t
match numerical values in one column and interpret them as tex
initials to another column:

(i.e. all numerical values of 501,412 and 478 in column B2 shoul
translate to text initials MKH in column A2. All numerical values o
732 and 15 in column B2 should translate to text initials AMW in colum
A2, and so forth...)

How can I do this? Please help me! I've attached a file for anyone t
check out if they need to.


:

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52283

 

[Anders S]

Hi,

VLOOKUP() should do it.

In a separate area, or in a named range on another sheet, create a table like

Col 1 Col 2
501 MKH
412 MKH
478 MKH
732 AMW
15 AMW
etc...

Then use VLOOKUP() in column A to pull the initials that corresponds to the
suppliers from the lookup table. See Excel Help on VLOOKUP() for more info.

HTH
Anders Silven