Excel 2010 MATCH function returns an error in conditional formatting

0
votes

When I enter the following formula in a cell it returns TRUE, but when I enter this into a new conditional formatting rule, it tells me I have an error.

This is the formula:

=ISERROR(MATCH(Table2[Website];Table13;0))

1
excelexcel-formulaconditional-formatting

1 Answers

0
votes

Use INDIRECT =ISERROR(MATCH(INDIRECT("Table2[Website]");INDIRECT("Table13");0))

Similar Question Here

INDIRECT():Returns the reference specified by a text string. References are immediately evaluated