I have a spreadsheet that has two worksheets...One has the physical counts taken at a store...The other worksheets is the master item table that contains the pricing, UPC's and other various information. I must match the Physical Worksheet UPC on one column in the Master Item Table as an exact match, or, match it to another column in the Master Table less the last digit in the Physical Worksheet UPC column. I have been working on this for two weeks and just can't figure it out. Can anyone help me with this? I have tried Crystal Reports, doing joins, etc. but I always keep coming back to Excel...I would be very grateful for any help...I wished I could attach the spreadsheet, but can't....Any help out there?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Help with Inventory-Job on the line Folks
- Thread starter prokf
- Start date
Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
Hi, welcome to the board.
There are several ways to do this in Excel.
One way would be to use the VLOOKUP function, but it's difficult to give a more precise answer without knowing more details of what your data looks like.
The VLOOKUP could almost certainly handle the exact match part, and it might be able to handle the match without the last digit.
There are several ways to do this in Excel.
One way would be to use the VLOOKUP function, but it's difficult to give a more precise answer without knowing more details of what your data looks like.
The VLOOKUP could almost certainly handle the exact match part, and it might be able to handle the match without the last digit.
Upvote
0
Similar threads
- Solved
