Using nested IF and Match to return multiple values if true/false

[esnelson426]

I want to have a formulat that put one of two different values ("IN" or "T") in the column if row A on US FULL SERVICE-Mdwst-West sheet matches the values in two different columns on the “Hotel accounts” sheet.

I think it’s more like a nested IF function….with a match function included in it… I’ve got the match part figured out but it only returns one value. I want it to say if it matches put a IN in the column, OR if it matches another range put a T in the column….

this is what i tried but it will only return one true and false value....
=IF(ISERROR(MATCH(D3,B$3:B$8,<wbr style="font-family: arial, sans-serif;">0)),"No","Yes (" & MATCH(D3,B$3:B$8,0) & ")")

 

[esnelson426]

It looks like you need:

=IF(COUNTIF('HOTEL ACCOUNTS'!A2:A25,A45),"IN",IF(COUNTIF('HOTEL ACCOUNTS'!B2:B25,A45),"T",""))

GENIUS!!! It worked!!! THANK YOU!!!