Index & Match - Sort Dilemma

[Anthonycess]

Hello,

I've read a few posts on this and still can't seem to get my issue resolved. In most instances, sort issues with Index/Match are due to the match formula referencing the spreadsheet name in the formula as opposed to just the appropriate cell (since you are already on that spreadsheet). This is not the case for me.

I have company name as a common field across multiple sheets, and I am looking to use Index/Match to look up the company name on the other sheets and display certain information that are in those rows (i.e., Company Grade, Employee Count, etc). I can get the formula to display this information properly, however for instance when I go to sort the "company grade" alphabetically, it throws off all the other fields. Here is the formula for that specific example:

Grade Field in the Output Table
=INDEX(Table13[Grade],MATCH([@Company],Table13[Company],0))

Source Table (table13):
WmvM0F9.png

Output Table:
lmxS97x.png

Thank in advance for your help!!


Anthony

[cbatrody]

Hi,

Welcome to the Forum.

Can you please post a sample file in excel format rather than image? Images are impossible to edit and nobody wants to recreate the file for you.

See the following URL for help on how to upload a file.
http://www.excelforum.com/members/da...ch-a-file.html

[Anthonycess]

Sure thing. Please see attached. I am pulling data in to the Account Summary sheet from the other two sheets. The challenge has been once I sort the summary sheet by different columns, it has been throwing off the rest of the data. I'm not sure that it is replicating in the sample data that I sent you, but perhaps you can have a look at this and if you need the actual data just let me know.

Thanks!!
Anthony