Hi All,
I'm looking for some help writing a formula that will lookup in descending order in column A to find the next lower value in column A and then return the value in column AD of that lower valued cell. I also need it to stop once it finds the first lower value. Right now I have a xlookup within an IF statement to search in descending order based on whether or not column AB is true, however it is grabbing the first equal value based on the match mode of -1. Any help would be much appreciated.
I'm looking for some help writing a formula that will lookup in descending order in column A to find the next lower value in column A and then return the value in column AD of that lower valued cell. I also need it to stop once it finds the first lower value. Right now I have a xlookup within an IF statement to search in descending order based on whether or not column AB is true, however it is grabbing the first equal value based on the match mode of -1. Any help would be much appreciated.
Excel Formula:
=IF(AB3=TRUE, "",XLOOKUP(A3,A$2:A3,AC$2:AC3,"",-1,-1))
