IF formula to include wildcard

[beckys]

I am trying to write an IF formula that includes a wildcard, and I must be doing something wrong... This is what I have currently:

IF(D3="*onhand*","Cash OnHand",IF(D3="*able*","ShortTerm",VLOOKUP(AA3,Sheet1!$N$2:$O$199,2,FALSE)))


Does anyone have any suggestions for what I could replace the wildcard characters with to do the same type of function?

Thanks!
Becky

 

[Jonmo1]

Try

=IF(ISNUMBER(SEARCH("onhand",D3)),"Cash OnHand",IF(ISNUMBER(SEARCH("able",D3)),"ShortTerm",VLOOKUP(AA3,Sheet1!$N$2:$O$199,2,FALSE)))

 

[number kruncher]

Try using the Count in the IF test, eg.

IF(count(D3="*onhand*"),"Cash OnHand",IF(count(D3="*able*"),"ShortTerm",VLOOKUP(AA3,Sheet1!$N$2:$O$199,2,FALSE)))

 

[beckys]

Unfortunately neither of these solutions are working. The first solution doesn't find the text, and moves to the vlookup function for everything. The second solution finds everything to be cash on hand. Any other thoughts? If I can provide additional information, please let me know.

Thanks so much!

 

[Jonmo1]

Works for me...

Excel Workbook
	D	E
3	Hello, I have 10 onhand dude	Cash OnHand
4	Hello, I am unable to continue	ShortTerm
Sheet1

 

[beckys]

I had an error in my formula - it's working now. Thanks to all for your help!