Here's my problem. I have two spreadsheets. In one spreadsheet (sheet a) i
have the part number P123456. in the other sheet (sheet b) i have a rang of
part numbers P00000-P66666 and the quantites of those part numbers. I need
to find the the part numbers that are listed in sheet a and match them with
the part numbers and quantities that are in sheet b. So i want find the part
number and quantity in sheet b and return it to sheet a. Please help