I am working with a database of products and I need to match products up with what vehicle they fit.

I currently use Microsoft Office 2007, but will get a newer version if needed for this formula since it would be detrimental to the project I am working on.

Example:

My Vehicles are all listed in in Row 1 so:

A1 is (Vehicle 1), B1 is (Vehicle 2), C1 is (Vehicle 3), ETC


The products that fit these vehicles are listed beneath them so:

A2 is (Product 1) B2 is (Product 5) C2 is (Product 7)
A3 is (Product 2) B3 is (Product 1) C3 is (Product 3)
A4 is (Product 3) B4 is (Product 7) C4 is (Product 1)
ETC


way on the other end of the spread sheet I have in say column ZX I have all of the products listed so:

ZX1 (Product 1)
ZX2 (Product 2)
ZX3 (Product 3)

I need a formula in column ZZ that will search for exact matches of (product 1) and anytime it finds a match it needs to post the data from the top of the column the match was found in (the vehicle it fits) into column ZZ if possible it needs to also separate the matches with a , or / or something my database can read as a separation.

Example:

ZZ1 found match for ZX1 (product 1) in A2, B3, and C4. So it needs to read the data in A1, B1,and, C1 and post into ZZ1 as (vehicle 1), (vehicle 2), (vehicle 3)
ZZ2 found match for ZX2 (product 2) in A3 So it needs to read the data in A1 and post into ZZ1 as (vehicle 1),
ZZ1 found match for ZX1 (product 1) in A4, and C3. So it needs to read the data in A1,and, C1 and post into ZZ1 as (vehicle 1), (vehicle 3)
ETC

I am sorry for the long post I am just trying to be clear in what it is I need and I am not good with formulas.

If I need to post the results in different columns that would work as well, say if the formula would only work for 1 column at a time I could do each column and merge the results later, but we are talking over 20,000 products and 1,000's of vehicles so anything to speed up the process is tremendous.

Thank you so much for taking the time to read my post and respond.