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 names.
I would like in sheet 1 column R row 4 to execute some sort of lookup to scan sheet 2 column A looking for a name, and if it finds a name that matches sheet 1 column A row 4 then it puts a T in sheet 1 column R row 4. If no match is found it puts a U.
Sorry if this sounds confusing, not even sure its possible.
6 Replies
- 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
