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(ISNUMBER(MATCH(A4, S:S, 0)), B4, IF(ISNUMBER(MATCH(A4, T:T, 0)), C4, D4))