Hi Scenario 2 workbooks with the same information . I need to do a
vlookup ( I think) to get the total number of orders for the company .
example workbook one has the name of the company as Arizona Chemicals Inc
THe other workbook has the name of the Company as Arizona Laboratories (they
are the same company) How can I do a vlookup so that these two match .
Maybe vlookup is the wrong function? All the names of the companies do not
exactly match in the two workbooks. thanks in advance Excel 2003