Auto-populate fields based on drop down selection

[kwo]

Hi there,

I have created a 3 tiered drop-down list with data validation, using different ranges.

My first drop down is looking at Product, then Country, then Industry. These are all linked via =indirect and ranges.

Depending on the selection of all three individual fields a cell shall be auto-populated with a number value.

I have all number values for each individual selected combination, but I am not sure how to link this/ create a table that will enable me to auto-populate a cell like this in the easiest way.

I really need some help!

Thanks

[mcmahobt]

We'd need to see how your data is setup to be able to give detailed help. Can you post a sample workbook?

[kwo]

Table1.xlsx

I attached an example table below.

[mcmahobt]

The easiest way to accomplish this without going the VBA and still having a contained, non-volatile formula would be to format your values table as seen in the example. From there, it is a simple array index/match to pull the correct results.

[kwo]

Hi Mcmahobt,

Thanks, it seems to be working great for the example with product a for brazil for any industry!

However, the drop down menu for countries is not working anymore? Any advise?

Thanks

[kwo]

Just figured it out. Thanks a lot!