I'm asked to do something brutally tough in Excel and I'm hoping it's possible.

Basically, I need to pick up a the next value from a list when a criteria in other another row and columns is met.

In the sample below, whenever the Downgrade value exceeds the last Major Level, the Upgrade Factor picks up the next value from Factors. On the next row, the Downgrade Factor picks up the next value from Factors. This continues until the last value in Factors is reached.

Also important to the logic is knowing when Max Upgrade Factor is reached.

I have a hunch that this might be possible with XLOOKUP, but I can't get it to work. How can this be done?

enter image description here


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.