Forum Discussion
Using IFNA to check matches in multiple columns
I am trying to adapt a current formula (IF(ISNA(VLOOKUP(A4,S:S,1,FALSE)),(A4&" "&C4),(VLOOKUP(A4,S:S,1,FALSE))) that checks if the number in Cell A4 matches anything in column S, the cell populates w...
=IF(COUNTIFS(S:S,A4),B4,IF(COUNTIFS(T:T,A4),C4,D4))