How to compare to columns for first > number and return results from a third colum

Hi guys!

What I would like to do is to be able to compare the numbers in column Y to the numbers in Column X, find the first instance where Y is > X (in this case 13) and then return the corresponding result that is located in the same row but in column Z ie 6 in this case. I can do it with a helper column that uses IF and then a simple Index-Match from there but I was wondering if there is a way to do it all in one formula?

Z X Y
1 5 2
2 6 3
3 7 6
4 8 7
5 9 8
6 10 13
7 11 15
8 12 17

Thank you!!!

Chin

This could be an option, confirmed as an array formula with CTRL+SHIFT+ENTER:

Please Login or Register  to view this content.

The -3 accounts for your data starting on row 4, not row 1. This can be avoided by changing the INDEX range to include A1, but this keeps things neater in my opinion.