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.