In the attached sample I'm trying to return values based on multiple IF functions but I need a wild card feature that doesn't exist. In plain language I'm trying to get the following:
IF(C3="TCF*,"TCF",IF(B3=1* or 2* or 3* or 4*,"FS","PS"))
I'm not sure if I need a CountIF or a Match?
Any help would be greatly appreciated!
Sick
Bookmarks