Hello,

I have the following:

A B
1 45 50
2 56
3 49
4 14
5 9
6 13


My formula I'm trying to work is:
=MATCH("<"&B1,A1:A6)
This doesn't work and I don't know why. Even the description for Match states it's able to handle logic functions. Even putting the cell reference into the formula, "<50" doesn't work. Is this not possible?