Index Match & MAX with Drop list

[Imran Magsi]

I have create i dashboard now i want to ranking from that data and select the top performer i have tow types drop list one in Locations and other is months.
when i select location and month my dashboard showing its data/graphs now i want to add top performer from it. please help.

[FDibbins]

1. upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
2. If you know how to do this without using drop-downs, then you also know how to do it with drop-down. Using a DD is exactly the same as if you typed the values into the cell

[Imran Magsi]

actual file is 1.6MB how can i upload it

[FDibbins]

We only need to see a sample large enough to show what you are working with, and what you want.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Imran Magsi]

Dear Thank you so much for helping me. I have solved with MAX formula in new cell and column and than vlookup.