Anthonycess
New member
- Joined
- Oct 6, 2015
- Messages
- 1
- Reaction score
- 0
- Points
- 0
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))
Thank in advance for your help!!
Anthony
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))
Thank in advance for your help!!
Anthony