I have a problem with Google Sheets Highlighting custom function and could use your help.
I have 2 sheets - ORIGINAL & RESULTS
RESULTS - contain the long list of company names in column A
ORIGINAL - contains list of PEOPLE who work for companies
ORIGINAL - has conditional formatting for all cells where CUSTOM FORMULA is =match(A2;indirect("RESULTS!A1:A");0)
The goal was for cells in Sheet ORIGINAL to be highlighted if they contain company names from Sheet RESULTS & Column A
Can someone then tell me why the situation, like in the picture below, happens?
Obviously, I want cell C2045 to be highlighted TOO as it contains the company name "Alliance Technology Polska," too, and "Alliance Technology Polska" was listed in the RESULTS Sheet in Column A
I have 2 sheets - ORIGINAL & RESULTS
RESULTS - contain the long list of company names in column A
ORIGINAL - contains list of PEOPLE who work for companies
ORIGINAL - has conditional formatting for all cells where CUSTOM FORMULA is =match(A2;indirect("RESULTS!A1:A");0)
The goal was for cells in Sheet ORIGINAL to be highlighted if they contain company names from Sheet RESULTS & Column A
Can someone then tell me why the situation, like in the picture below, happens?
Obviously, I want cell C2045 to be highlighted TOO as it contains the company name "Alliance Technology Polska," too, and "Alliance Technology Polska" was listed in the RESULTS Sheet in Column A
