Oct 07 2020 04:52 PM - edited Oct 07 2020 04:53 PM
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.
Oct 08 2020 12:06 AM
Oct 08 2020 12:09 AM
Oct 08 2020 12:26 AM
@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
Oct 08 2020 12:52 AM
Oct 08 2020 01:00 AM
@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.
Oct 08 2020 01:02 AM