Searching a comma delimited string in a cell

Hi there.
I'm putting together two work sheets for a cost analysis spread sheet.

In one sheet, the user inputs the following:

1. Description i.e. Shovel
2. Cost i.e. $15.00
3. What years cost occurs i.e. 0,4, 10, 19

On the other sheet, have the cash flow model with the following

Description
Year Shovel
0
1
2
3... all the way to 50.

What I want to do is have the column that shows the description at the particular year, to pull the info from the "What Year Cost Occurs" and drop it into the particular cell for that year.

I was first using this function =IF(ISNUMBER(SEARCH($A3,Costs!$C8)),Costs!$B3, "0")

to compare the cell with the data showing the comma delimited string but the problem is that it if a cost occurs in year 10, it reads the 10 as a 1 and a zero so it assumes that year 1 occurs when year 10 is listed.
Any VB scripts out there that can help?
I guess the best way is to take the string, convert it into an array, then search the array, then return the value of the cost if the number matches the array value.


Any help is appreciated.
Migpics

Tried it but it still pulled the number from the spreadsheet.
I attached the file to look at.
Thanks
migpics

Oops.
I didn't catch that.
Here it is in Zip format.
thanks
migpics

Sweet! That works!
I have to really dig into it so see how it works but it does.
The next step will probably be to refine it with some VB to allow the user to say that costs occur every 2 or 3 or 4 years etc.
Thanks.
migpics