Hello,
Im working on an Excel project that uses an index function to match a series of ID's with their corresponding P&L figures to return another corresponding class ID. Originally, the P&L figures were unique throughout the series of ID's, so I didn't have any issues with getting the corresponding class to return. However, using a new set of data, I am finding that I have some ID's with multiple 0's throughout, which causes it to return the same class multiple times.
I'd like to attach an example worskeet, but I don't see an option to do so? Here's the function I am using:
Anyways, if someone knows a solution to this, or can guide me on how to upload this file, I would greatly appreciate it.
Im working on an Excel project that uses an index function to match a series of ID's with their corresponding P&L figures to return another corresponding class ID. Originally, the P&L figures were unique throughout the series of ID's, so I didn't have any issues with getting the corresponding class to return. However, using a new set of data, I am finding that I have some ID's with multiple 0's throughout, which causes it to return the same class multiple times.
I'd like to attach an example worskeet, but I don't see an option to do so? Here's the function I am using:
Code:
=INDEX(CS!$C$2:$C$25, MATCH($A2 & "|" & $D2, INDEX(CS!$A$2:$A$25 & "|" & SUBTOTAL(9,OFFSET(CS!$D$2:$F$2,ROW(CS!D2:F25)-ROW(CS!D2),0)), 0), 0))
