I'm trying to use this function =IF(COUNTIF(sheet2!B:B,D7)&(sheet2!C:C,C7),sheet2!B2,"") to check IF (D7 in this sheet = any cell value in sheet2 in column B:B) and IF (C7 in this sheet = any cell value in sheet2 in column C:C) if ok so to return with "B2" value otherwise to keep the cell blank but i get #VALUE error
IF D7 = sheet2!B:B
AND IF C7 = sheet2!C:C
make the cell = B2 in sheet2, if NOT keep it blank
How to retype it in the correct way?
IF D7 = sheet2!B:B
AND IF C7 = sheet2!C:C
make the cell = B2 in sheet2, if NOT keep it blank
How to retype it in the correct way?