DNapoli
New Member
- Joined
- Mar 13, 2012
- Messages
- 35
- Office Version
- 365
Can someone help me get this to work. Currently becasue I added the last if statement it does not work.
Thanks!
Danielle
=IF(G2="FDIC","FDIC",IF(ISNUMBER(SEARCH("*GSK*",H2)),"GSK",M2)), IF(ISNUMBER(SEARCH("*DCM*",J2)),"DCM",M2)
Thanks!
Danielle
=IF(G2="FDIC","FDIC",IF(ISNUMBER(SEARCH("*GSK*",H2)),"GSK",M2)), IF(ISNUMBER(SEARCH("*DCM*",J2)),"DCM",M2)