Adding Cost Codes

W

Wrenn

Help please! I need a macro. I have a cell with several
sets of numbers in it, i.e. 152, 143, 765, etc.

Each number is a cost code that corresponds to an amount
in another workbook. I need to add the corresponding
amounts.

I'd really appreciate any help. Thanks.
 
T

Tom Ogilvy

Look at the vlookup function in Excel help.

=Vlookup(a1,'[MyCostcodes.xls]Codes'!$A$1:$B$200,2,False)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top