Hi – I was searching the forums for an answer to this, with no luck, and I was hoping someone could help.
I am using an index/match to return (a name) from the row above (the name) in worksheet "Mtg Portfolio Data". The name to search comes from a dropdown menu in cell B1 on worksheet Peer Comparison
=IFERROR(INDEX('Mtg Portfolio Data'!$A$3:$A$220,MATCH('Peer Comparison'!B1,'Mtg Portfolio Data'!$A$3:$A$220,0)-1,1),"")
The formula does exactly what I want, except when the name in cell B1 is on top of the list (in cell A3). In this instance the return is “+2”.
A
B
C
D
E
If I choose B, I get A, which is what I want.
If I choose A, I get C.. which I don’t understand. I want an error/blank.
Bookmarks