Index with multiple IF statements

[Yves2509]

Hi Guys,

Trying to work on a Top 10 list for the automotive market within the Middle East.

In the example you can see I have only created a basic overview. Included is the Segment, Bodytype, Brand, Country and units.

I have managed to create a pull down where I am able to select the country. While the units correspond to the left table the Brand and Model does not.

Example, when selecting Bahrain, I get the top 2 models which are correct. The third which should be Mercedes C ends up coming as VW Jetta even though it comes under the category of Kuwait. The Mercedes C and VW Jetta have the same units and therefore when the country is selected the brand and model only takes the first of the duplicated number, irrespective of Country.

Therefore I would need to create another IF statement within the cells under Brand & Model.

As a rookie please excuse the formula within here as I took it from another document and adapted it to mine. However this can not deal with duplicates.

I hope I have managed to explain the problem and haven't left anyone confused more than I am!

Attached is the file:
Car Market - Help.xlsx

[rajeshturaha]

Hi Yves2509,

Welcome to the forum.
Plz check the attachment for your desired answer. i have used a helper coloum in E, and modified the formula in N.

Plz see if this resolves your problem.