Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formulas???
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |