JackChang
06-16-2020, 03:08 PM
All-
I have a list of descriptions on tab one and a list of keywords on tab two. Is there a formula that looks up my keywords on tab two, against the list on tab one? I'm trying to find where they match.
For example, if I lookup my keyword 'BRP120AF' on tab one, it will match rows 1423, 1424, 1425 (CIR BRP120AF PLUG ON 1P20A AFC).
Either highlighting these rows, or having an 'X' in a blank column works.
Any ideas? Sample file attached.
Thanks in advance!
I have a list of descriptions on tab one and a list of keywords on tab two. Is there a formula that looks up my keywords on tab two, against the list on tab one? I'm trying to find where they match.
For example, if I lookup my keyword 'BRP120AF' on tab one, it will match rows 1423, 1424, 1425 (CIR BRP120AF PLUG ON 1P20A AFC).
Either highlighting these rows, or having an 'X' in a blank column works.
Any ideas? Sample file attached.
Thanks in advance!