I am stumped on how to do the following comparison / validation. I have two workbooks that look like this:
Item Value ValueFromOtherWorkbook
C 5 ? <-- the value I want in this cell is 3
A 1 ? <-- the value I want in this cell is 1
The list in each workbook are in a Table - not sure if that matters.
I have tried the Index and Match functions as well as vlookup.
Ultimately, I want to check all of the values in Workbook 2 that match up with items in Workbook 1.