Need Help Proofing My Formula - Thanks in advance!

Hi All,

I am working on typing in a complex nested function in excel. Here is a little background on the problem I am having:

-The formula exists on Sheet1, and in the formula, I reference a range called "DealerByMake" on Sheet2
-The "DealerByMake" range is actually a matrix, where column A tells me the name of the dealer, and row 1 serves as a header, listing out different car makes. In the body of the matrix, cell values are either blank, or contain a number in them. If a cell has a number, that is the number of cars a dealer sold of that particular make over a time period I have previously defined.

What I am trying to do, is make a formula that will tell me for each dealer I specify (and I am trying to automatically reference it in the formula), what their most popular make of car is that they are selling. This formula revolves around finding the MAX value of a particular row, defined by the dealer name that is referenced on Sheet1, then referencing that location and specifically looking at the column number, and then returning the contents of a cell whose location is on Row one, and in the same column as the MAX value.

Here is the formula I currently have: "=CELL("contents", INDEX(DealerByMake, 1, CELL("col", MATCH(MAX(CELL("row", MATCH(A8, DealerByMake))), DealerByMake)),1))"

I have make some small tweaks to it a few times, but nothing is working for me. I would appreciate anyone that could help me troubleshoot what I am doing wrong.

Thanks!

PS - See the 2 pics below for Sheet1 and Sheet2

Hello, See if the attachment works for you....