Issue with double IF

[slam]

I'm trying to build a formula for the following:

If D2 = any part of H2, ORD
else if D2=N2, WBS
else Not Ready

Here's what I have, that Excel is not happy with. Where am I going wrong?

=IF(D2="*"&H2&"*","ORD",IF(D2=N2,"WBS","Not Ready")"Not Ready")

Thanks!

 

[Joe4]

Can you show us some examples of what you mean by "D2 is any part of H2"?
Because the way you coded it looks backwards of your description, so I am not sure which one is what you really mean.

 

[Fluff]

Maybe

=IF(ISNUMBER(SEARCH(D2,H2)),"ORD",IF(D2=N2,"WBS","Not Ready"))

But like Joe I'm a bit confused by your formula.

 

[slam]

Can you show us some examples of what you mean by "D2 is any part of H2"?
Because the way you coded it looks backwards of your description, so I am not sure which one is what you really mean.

Sorry, I started out with a different formula, and I probably didn't evolve it very well. I started using COUNTIF to do this before changing it to just IF and then the double IF.

Anyhow, Fluff's formula is doing exactly what I need it to, so thank you very much!

 

[Fluff]

Glad we could help & thanks for the feedback.