I need to match all the Storage Numbers with the correct Item Number or Screen Number

J

JJohnson

Ineed a solution for this problem...

I have an Excel Workbook that contains 3 Worksheets. Worksheet 1
contains "Storage Numbers" with the suffix FS. Worksheet 2 contains
"Item Numbers" with the suffix CD. Worksheet 3 contains "Screen
Numbers" with the suffix SS. The Storage Number without the FS will
match an Item Number or Screen Number without the CD or SS

I need to match the Storage Numbers with the correct Item Number or
Screen Number. The Stroage Number on Worksheet 1 A1 do not correspond
to an Item Number on Worksheet 2 A1, the match could be in any row on
Worksheet 2 or worksheet 3. Any ideas how to do this easily? Right now
I am importing each sheet into Access, running a match query and
exporting the result back into Excel. My goal is eliminate Access's
involvement in this process.

Thanks in advance!
 
Top