Forum Discussion
Verify data from sheet to sheet
Hello! I am trying to have data change on sheet 1 based on data in sheet 2. This is what I would like: I have sheet 1 column B a list of names. I have sheet 2 column A a list of name...
- Thanks! I'll give it a try.
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?
