Hi
I am unable to get a conditional format to work correctly using a combination of index/match, I've added in the indirect formula so that I'm able to use my structured table references this gives me:
=INDEX(INDIRECT("Tbl1"),MATCH(A2,INDIRECT("Tbl1[ID No]"),0),8) which works correctly in a cell to return the matched number which just happens to be 19, however what I'm trying to do is put that into a conditional format so that if the index match result is greater than 10 colour the cell.
I've tried combinations of =INDEX(INDIRECT("Tbl1"),MATCH(A2,INDIRECT("Tbl1[ID No]"),0),8)>10 but nothing seems to happen, any advice is welcome
I am unable to get a conditional format to work correctly using a combination of index/match, I've added in the indirect formula so that I'm able to use my structured table references this gives me:
=INDEX(INDIRECT("Tbl1"),MATCH(A2,INDIRECT("Tbl1[ID No]"),0),8) which works correctly in a cell to return the matched number which just happens to be 19, however what I'm trying to do is put that into a conditional format so that if the index match result is greater than 10 colour the cell.
I've tried combinations of =INDEX(INDIRECT("Tbl1"),MATCH(A2,INDIRECT("Tbl1[ID No]"),0),8)>10 but nothing seems to happen, any advice is welcome