Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Name based on the account number
I receive the excel report with about 80 different account numbers and
multiple charges against each account number. I can't tell by the account number who the vendor is. How can I insert a column to populate it with vendor names based on the account number. Can I setup some hidden table to do this automatically once and for all? Any other method? Each account may have multiple rows. acct invoice date amount 123 12121212 01/15/09 $365.15 123 12121334 01/18/09 $105.00 125 30987652 01/16/09 $250.40 Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Name based on the account number
set up a table with acct and vendor and then just use VLOOKUP. Look in the
help index for VLOOKUP -- Don Guillett Microsoft MVP Excel SalesAid Software "Vic" wrote in message ... I receive the excel report with about 80 different account numbers and multiple charges against each account number. I can't tell by the account number who the vendor is. How can I insert a column to populate it with vendor names based on the account number. Can I setup some hidden table to do this automatically once and for all? Any other method? Each account may have multiple rows. acct invoice date amount 123 12121212 01/15/09 $365.15 123 12121334 01/18/09 $105.00 125 30987652 01/16/09 $250.40 Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Name based on the account number
You can use a simple Vlookup() function in say Column E,
with a datalist of account numbers and names in an "out-of-the-way" location, in say Columns AA and BB. Account numbers in AA1 to AA80, Corresponding account names in BB1 to BB80. Enter this formula in E2: =IF(A2="","",VLOOKUP(A2,AA$1:BB$80,2,0)) and copy down as needed. A return of the #N/A error means you haven't added that account number to your datalist yet. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Vic" wrote in message ... I receive the excel report with about 80 different account numbers and multiple charges against each account number. I can't tell by the account number who the vendor is. How can I insert a column to populate it with vendor names based on the account number. Can I setup some hidden table to do this automatically once and for all? Any other method? Each account may have multiple rows. acct invoice date amount 123 12121212 01/15/09 $365.15 123 12121334 01/18/09 $105.00 125 30987652 01/16/09 $250.40 Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: graduating fees based on account value | Excel Worksheet Functions | |||
sumif based on last digit of account list | Excel Worksheet Functions | |||
How do move folders from web based email account to outlook? | Excel Discussion (Misc queries) | |||
Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
Insert a number of rows based on a value in a cell on active row | Excel Worksheet Functions |