Hello,
I have a list of surnames in sheet 1, column B
I have another list of surnames in sheet 2. column B
What i want to achieve is for the list in sheet 2, to be compared to the list in sheet 1, and return either a YES or a NO (TRUE or FALSE would work fine), in sheet 2, column C - next to the corresponding name
so i want to ask excel to look up the name in Sheet2!B1, in my column Sheet1!B:B
and if it finds a match, return "YES" in Sheet2!C1, if it does not find a match, return "NO" in Sheet2!C1
i hope that makes sense, i have been playing around with the IF, VLOOKUP, and MATCH functions all morning but i cannot seem to get it right.
Thanks.
I have a list of surnames in sheet 1, column B
I have another list of surnames in sheet 2. column B
What i want to achieve is for the list in sheet 2, to be compared to the list in sheet 1, and return either a YES or a NO (TRUE or FALSE would work fine), in sheet 2, column C - next to the corresponding name
so i want to ask excel to look up the name in Sheet2!B1, in my column Sheet1!B:B
and if it finds a match, return "YES" in Sheet2!C1, if it does not find a match, return "NO" in Sheet2!C1
i hope that makes sense, i have been playing around with the IF, VLOOKUP, and MATCH functions all morning but i cannot seem to get it right.
Thanks.
Last edited: