Hello,
In the example attached.
On Sheet2, I want to lookup matching values in column A on Sheet1 if the value on Sheet2/B1 is found on Sheet1 and return the words FOUND.
Hard to explain, but the example attach will show what I am trying to do.
I appreciate any help.
Thank you,
Nick
Bookmarks