Hi,

I am pretty new to Excel. I want to be able to import data from a number of
client trading reports and the client's account number needs to be converted
into an advisor's name. Say I have 20 advisors, and each advisor has 50
clients, I need to get excel to put the appropriate adviser's name next their
client's account number if it appears in column A.

For example, if I import the below data, I would like to create a formula
which says "if A1 = U11111 then enter the word "Megan" appears in B2", "if A1
= u11112 then enter the word "Jane" in B2" and so on. I will need to create
about 1000 if statements for each row in the column A, which will result in a
different name in column B.


A1 U11111 B1 *advisor's name*
A2 U11112 B2 *advisor's name*
A3 U39393 B3 *advisor's name*
A4 U23893 B4 *advisor's name*
A5 U23930 B5 *advisor's name*
A6 U39290 B6 *advisor's name*
and so on...
Your help is greatly appreciated.

Natasha