Cross-reference / lookup data from one tab and display on another - How to
Greetings. I have two spreadsheets that were created before I started and my customer has now requested that all the data be on one spreadsheet. I have them as separate tabs on the same file, but would like them on one sheet without doing a lot of back and forth manual entry work (my assistant is busy with other tasks and I simply don’t have the time). I was wondering if there is any way to look-up the fields for Columns C-E on the second tab ‘Purchase Order Log’ and display them on the first tab ‘Catalog Master Copy’. I tried messing around with the VLOOKUP function, but keep coming-up empty-handed or riddled with error messages. There are several items that may not be capable of cross-referencing. As in, an item may be on the first tab that is not on the second one and vice-versa. I originally thought that the SKU# would be a good variable to use for cross-referencing, but there are several instances on the second tab (the PO Log) where the same SKU# us listed multiple times with different PO#’s and VCD dates. Any help or advice would be much appreciated. I will log in later today to follow-up. Thank you all in advance for the assistance.
|