Adding lookup table to existing spreadsheet

I had fantastic help yesterday in this thread:
http://www.excelforum.com/excel-gene...of-search.html

I have attached the current work to this thread.

I would like to add one more piece to this spreadsheet.

As an example, at the top of the Ad page is a product called CA-30.
Right now the sheet will check for CA-30 against the schedule and return dates that we will be making that product again.
There is the possibility that we can use CA-30 in other products. Possibly in CA-350.

Is there a way to create ... and I hope the terminology makes sense ... a lookup table to allow one value (in this case CA-30) to check for multiple values (in this case CA-30 and CA-350) on the schedule?

In other words, have the spreadsheet see the CA-30 on the Ad page. Then look at a table (or other means of cross-reference) to see that CA-30 = CA-30 and CA-350? Then go to the schedule and look for both CA-30 and CA-350 and return dates on the CA-30 line on the Ad page for both CA-30 and CA-350. This will give each line the ability to look for multiple products on the schedule page.

I hope this makes sense.

Thanks,
Anthony