1

I want to highlight text in cells in one column in one sheet that matches text in cells in a column in another sheet. =match(A1;B:B;0)>0 is working for columns within the same sheet, but =match(A1;"Sheet2!B:B";0)>0 doesn't seem to do the trick for what I want.

Is this possible?

player0
  • 124,011
  • 12
  • 67
  • 124
soulitude
  • 111
  • 1
  • 2
  • 11

1 Answers1

3

you need to use INDIRECT:

=MATCH(A1; INDIRECT("Sheet2!B:B"); 0)>0
player0
  • 124,011
  • 12
  • 67
  • 124