Thread: If or formula help
View Single Post
 
Old 04-24-2018, 03:03 PM
zhead zhead is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Mar 2015
Location: Texas
Posts: 32
zhead is on a distinguished road
Default
Is it possible to combine these? If not no big deal. I will just use separate columns for the tables.

=IF(Isnumber(Match(A2,$Y$2:$Y$10,0)),"NSA","")+
=IF(Isnumber(Match(A2,$Z$2:$Z$10,0)),"MEAAP","")+
=IF(Isnumber(Match(A2,$AA$2:$AA$10,0)),"EUM","")
Reply With Quote