Column X contains a list of all companies.
Column Y is used for a simple check (values would be yes, no, n/a)
In column Z I have a partial list of company names.
Here is what I need help with:
I need to start at Cell z2 see if that value matches ANY value in my column X Range (x1:x1000)
If yes I need to update value in column b with a yes
How can I do this?
Thank you in advance.
Column Y is used for a simple check (values would be yes, no, n/a)
In column Z I have a partial list of company names.
Here is what I need help with:
I need to start at Cell z2 see if that value matches ANY value in my column X Range (x1:x1000)
If yes I need to update value in column b with a yes
How can I do this?
Thank you in advance.