I wasn't sure exactly how to title this, but what I'm trying to understand if it is possible to look up specific text in a range which will contain duplicates and return true if there.
Example:
C1 C2
Client 1 OK
Client 2 OK
Client 2 High
Client 1 OK
Client 3 High2
Client 1 OK
Client 3 OK
I want to look up "Client 1" in Column 1 to see if the word "High" appears in Column 2 for them, if so, return "High", otherwise "OK". I know your general lookup function would first the first result and return whatever it finds. I need it to look at all possibilities and then make the decision. If a formula is not possible VBA is fine too. I was unsuccessful in searching for this as I was not sure how to search it.
Bookmarks