I have the following data and I would like to be notified or alerted or TRUE when the following occurs across several sheets.
Sheet 1 Sheet 2 Sheet 3
A B A B A B
1 hi yes yellow no house yes
2 bye no blue no apartment yes
3 yes red yes no
4 yes
I would like to search column B to find yes or no and see if there is text in column A, if there is no text beside column B across the 3 sheets I would like to be notified, or TRUE.
I have included an image with different data but the same idea. sample sheet.png
Thanks!!
Bookmarks