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

Ok, as Im sure most of you will soon be able to tell...I dont know what Im doing.
But, I am trying.

Revised file attached.

I added a Key tab at the bottom. Mostly just a mess for me to try to link an index/match to.
On the Po tab in F3 I put the following:

Please Login or Register  to view this content.

Used Ctrl, Shift, Enter and it comes back blank.

Im not sure how to tell where I am failing (besides skill)

I was hoping my addition of the index and match would allow this to go to another page, find the match to A3 on the Po page (which should be APNDPT-300) and look for the same row in column B.

While this still doesnt answer my question from above, I was hoping to build off of this.

Thanks,
Anthony