Dependent Data Validation

[twocoffeesnobs]

Hey All,

I hope I will be able to explain this correctly.

Okay,

Excel workbook, two sheets.

Sheet 1 = Make your selection
Sheet 2 = The Data

in A2, Data Validation to a table named ProductList3 (Facade Garage Door etc...)
in C3, the vlookup product code (SLE, HL, OFF etc...)
in A5, I need a list returned, based on the above two selections

Now, the tricky part,

Some products in ProductList3 share the same product code, based on the product code, I need a list returned from the appropriate list on Sheet2 (PRODUCT MATRIX).

Example,

A2 = Facade Garage Door
C3 = FGD
A5 = FGDList

That's part one of my problems. From here, Once the Product, Product Code & ProductList has been selected.

I have been trying and trying to get this too work...

I have tried =indirect(vlookup) | offset | indirect | vlookup etc...

Nothing I seem to do works?

Optional extra and happy to pay for help on this one?!

When you have picked your LIST (EG: FGDFList) and then your product type (GL) I need a picture copied from the correct picture for FGDFList - GL to appear on the PRODUCT Sheet.
**The reason it must be the correct image from the correct list, GL as you will see in the sample, will appear in multiple categories, so the image auto-picked must come from the correct list (GL from FGDFList, not OFFList)

The kicker to all of this... I cannot use or accept VBA for any of this as it's eventual life will be a hosted web-app for sales reps

Thank you for your help and time...

[davsth]

For a5 a data validation list

source
=INDIRECT(C3&"list")

for the last part
https://www.google.com/url?sa=t&rct=...MAyhrVNAKNsFa7

or
https://www.excelguru.ca/content.php...P-for-Pictures

[twocoffeesnobs]

Thank you, but still confused.

Can you please explain it in more detail?

[JeteMc]

As to the dependent data validation in cell A5:
1. Produce named ranges from each of the tables in columns D:I on the PRODUCT MATRIX sheet
2. Modify davsth INDIRECT function, used it as the source of the data validation, to read: =INDIRECT(C3)
The result of the above is modeled in the attached file.
Let us know if you have any questions.