Conditions: spreadsheet with a list of id numbers in column A; adjacent cell in the same row of column B could contain a value or it could be empty. I need to find a specific ID of a range in column A and return true if the adjacent cell in column B contains a value or false if the cell in column B is empty.
If possible I would enter the test ID in C2 and have the true or false written into D2.
I don’t know which is the proper function to use and how to set it up in a formula. I do understand somewhat how to use find, search and vlookup, but setting up a working formula is currently beyond my ability.
Thanks for any help.