Need Help: Dynamic Matching that then backs into the header source

[goose7856]

Hi everyone,

I am new to the board, but I have been lurking/following for awhile now. I am always amazed at the solutions you are able to design.

Here is what I am trying to do...I have created a drop down ("Criteria 6" is selected that links with cell K22. When the drop down changes, then so does cell K22. In cells L22 through Q22 I have an equations that take the max, (large,2), (large,3), min, (small,2), and (small,3) by looking in the corresponding row for Criteria 6. In this case, it would look in row 10 and give me the the top and bottom 3 results.

So that part works. Here is the issue:

I need to have the part in yellow tell me the correct column where the output beneath it came from. So, for cell L21, I need to know where the 3.40 came from...I need cell L20 to give me the output "Name #5" from G10 since that is where the max from row 10 is from.

How can I do this? I don't even know what this would be called...I've tried using every combination of vlookup, lookup, hlookup, index, match, dmax, etc formula that I can find and I am stuck.

I appreciate your help. Please let me know if the above is not clear.

 

[goose7856]

Bump. Thanks

 

[goose7856]

Anyone?

 

[goose7856]

I'll keep on trying...thanks!

 

[goose7856]

Update: I was able to figure out a solution. I created a pivot chart and then added a slicer to make it interactive. It delivered the desired output.