I have a spreadsheet where I want to check several things

I'll try and keep it simple:

To start, I want to go the function to compare the value in cell A1 with the all the values in Column B.
If, for example, A1<any cell in Column B, let's say, in the example below, B3 and B4, then I want it look at the correspondent value in Column C, C3 and C4. Then I would want it to return the row in which it found the highest value in column C which, as stated above, has a corresponding value in B that was less than the value in A.


I'd like to put that formula beside cell A1, so that I can tell which row is, if you will, below budget but has the highest value.


Something like this:

A1 = 45



COL COL COL
ROW A B C
1 45 32.3 101
2 42.6 115
3 54.3 156
4 64.1 124
5 22.3 111

So, in this example, the result would be 3, since both B3 and B4 are greater than A1, but C3 is higher than C4.

Of course, columns B and C are pretty long in my real spreadsheet.

Thanks for any help!