Multiple Selection

[Barrera006]

Hi,

I'm struggling with trying to have two selection's that return a result. Is this possible?

I have attached a demo file to show what I'm looking to achieve. In short, if I select the desired location and then the desired manufacturer it should return a supplier.

i.e. Location - Goring, Manufacturer - Audi should return "Woods".

Any help appreciated with the formula.

Book1.xlsx

[newdoverman]

I would re-arrange your data and use INDEX MATCH to find the supplier.

[Barrera006]

Great shout but there's a hole database of detail that needs to be returned hence the way I need to manage it.

Thanks for your help though, appreciated.

[FDibbins]

Try thi, using a helper column.

J6=IF(A6="",J5,A6&G6)
copied down

H3=INDEX($H$6:$H$10,MATCH($H$1&$H$2,$J$6:$J$10,0))

[Barrera006]

Try thi, using a helper column.

J6=IF(A6="",J5,A6&G6)
copied down

H3=INDEX($H$6:$H$10,MATCH($H$1&$H$2,$J$6:$J$10,0))

Sadly that's not working.

The issue I have is that I have a database that needs to be accessed by six locations but each location has different supply due to the distance between each location. Thus each location needs to select their location and which manufacturer they require and then the rest should be self population based on the database. Its easy with just one option in supply because VLOOKUP covers this but with the requirements being multiple it changes.

Any help appreciated.