I'm trying to do a Comparrison of products of differant Companies.
My Excel Data is like this called lookup:
Company Product Item Description Character1 Character2
Character3 etc.
The moment I have the Item I can link the Rest like Description, Character1
etc via vlookup because it is unique.
Under a product one company can have more than one Item. I started with Data
Validation because this gives me an easy drop down list. For products. Then
I created one for Companies. Now I am stuck because I hoped to do a lookup
with a combo of Product and Company to give me a dropdown list of just the
items that exist against this combo but I can not get it right! The formula
that I used is =Indirect(Vlookup (of the Product and Company cells) where I
created the Company and Products as named lists. This is suppose to now
lookup my Data in the lookup database.

Can some one please help. The alternative would be VB to maybe replace the
named list with Items out of the database where the combo of Company and
Product is valid?

Tx