Which non-contiguous range contains value?

[LloydFinancials]

A B
1 (14.73) (16.29)
2 500.00 600.00
3 1,045.92 1,156.02


A is one end of range, B is the other. Formula to determine which range contains the value 501.00 and return the row number. The next list may have 9 rows or more, so cannot enter if statements to check every single row. Formula preferred.

 

[DanteAmor]

No problem. It must be a bit annoying having to translate all the time.
Do you normally do it manually or use a translator like this?

If it is a problem for me. All the time I have to translate the formulas. Sometimes manual, sometimes I search the web for translation and on many occasions I use ExcelJeanieHtml.

But in hundreds of responses, they have only been passed to me like 3 times, and I think nobody has suffered damage

Thank you all for your compression. I will be more careful.

 

[Peter_SSs]

But in hundreds of responses, they have only been passed to me like 3 times, and I think nobody has suffered damage

I agree - no harm done.

I will be more careful.

I don't think you need to be any more careful, you do a great job if you are translating all the time!

 

[DanteAmor]

I don't think you need to be any more careful, you do a great job if you are translating all the time!

Thanks again Peter.