Nested IF ordering issue

Thanks, but that is not quite working. The first part of the formula, (c2 = "*abc*", 0), I am just checking one cell for these letters and if they are in that cell I need a value of 0 returned. The Match function seems to be useful for an array which I don't have here and I need a specific value returned (0).

Alan, Almost there, The first part evulates ok if "abc" exists, however if "abc" doesn't exist then I get #VALUE. If "abc" doesn't exists then I need to use the second part to determine the rate.

Worksheet 1:
....|C|........I|J //columns
2...|abcdef|...bob|rate here|
3...|abc123|...joe|rate here|
4...|xyz|......tom|rate here|

Worksheet "data"
Table
...E|F|...
...joe|10
...bob|10
...barb|10
...jill|0
...tom|0

Hopefully to save those who don't want to open an attachment a quick ref above otherwise a sample worksheet is attached.

Here is what is going on:
For worksheet 1, column J, in each row I need to look at column C. If in Column C the data starts with "abc" (it can more text than just abc but must contain the abc), then the rate in column J is going to be 0 regardless of any other info in column I. If column C does not start with "abc", then I need to look up the name selected(from a drop down list) in column I and the result for column J is the applicable rate for that person. The dropdown list is located on Worksheet called "data" located within the same workbook. The list/table spans E2:F13 of the worksheet.

I started with this:
=IF(C2 = "*abc*", 0, IF(ISNA(VLOOKUP(I3, Data!$E$2:$F$13, 2)),0, VLOOKUP(I3, Data!$E$2:$F$13,2,)))
This did not work because C2 evaluated as false with data such as, "abcdef" Not sure if the entire statement would work if I got the first part to work.

Now I am here:
=IF(FIND("Intro",C5),0,IF(ISNA(VLOOKUP(I5,Data!$E$2:$F$13,2)),0,VLOOKUP(I5,Data!$E$2:$F$13,2,)))

So, Alan suggestion of using find almost works, but if "abc" is not found I get a return value of #VALUE in column J. The ordering of the IFs (I am guessing) is causing the first if to be evaluated but the second part of the formula is not being evaluated.

I have also tried reversing the If order, but I get an error of "too many arguments"
=IF(ISNA(VLOOKUP(I9,data!$E$2:$F$13,2)),0,VLOOKUP(I9,data!$E$2:$F$13,2,), IF(FIND("abc",C9),0))

uuuugh! Any suggestions?example.xlsx

Sorry about the typos. I was copying from the actual spreadsheet to an example sheet and slid over a column..... and yes it should be 10.

Ahh, yes...this is working. I will run it through some more and make sure I have what I need. But I think this is the ticket.

Many thanks to all. Dilly

You're welcome. Thanks for the 'star tap' and thanks for marking your thread SOLVED.