I have one workbook, with two separate worksheets. I want to know if the values that appear in worksheet B also appear in worksheet A, if so, I want to return a "YES". If not, I want to return a "NO".
(Example: Worksheet A is a list of overdue books. Worksheet B is the entire library).
In worksheet A, I have the following data set:
A 1 AB123CD 2 EF456GH 3 IJ789KL 4 MN1011OP
In worksheet B, I have the following data set:
A Overdue 1 AB123CD ? 2 QR1516ST ? 3 EF456GH ? 4 GT0405RK ? 5 IJ789KL ? 6 MN1011OP ?
How would I structure the function in order to properly look up if the values exist in Table A?
I've been playing around with a combination of if(), vlookup(), and match(), but nothing seems to work for multiple worksheets.