Adding Cost Codes

  • Thread starter Thread starter Wrenn
  • Start date Start date
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.
 
Look at the vlookup function in Excel help.

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