Forum Discussion
Verify data from sheet to sheet
Is it reversible as well to check sheet 1 against sheet 2?
rrbailey Sure, no problem. The first element inside the VLOOKUP (A4) is what you want to search for and the second part is where you want to search for that value (Sheet2!A:A). The 1 tells Excel to return the value in the first column (in this case you only search in one column, i.e. column A in Sheet2) and FALSE (or 0) means that it has to be an exact match.
Normally, this will return the name found or #NA! if not found. But since you want "T" if found and "U" if not, I had to wrap the VLOOKUP in IF and ISNA() statements.
More about VLOOKUP (or its successor XLOOKUP) here:
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
- Riny_van_Eekelen will the names in the various sheets not being in the exact same order matter? For example if "Bob" is in row 4 on sheet 1 but row 3 on sheet 2 will T still be properly applied to R4 in sheet 1?
rrbailey The VLOOKUP function (or XLOOKUP) will look-up a value in another range of cells. Is doesn't matter how that range of names is sorted or where the names are witting that range. If it exists anywhere in that range, it will return the matching value.
Now, in some instances your lookup range must be sorted, but I don't believe that is relevant in your case.
- Great! The goal is the find "Bob" in sheet 2 in X row and Match it to Bob in sheet 1 in some other random row and if it's there place the value.
I'm looking forward to trying this out later on, thanks for your help!