Logic functions in MATCH()

**weeble33** · 05-15-2013, 02:38 PM

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:

Please Login or Register  to view this content.

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?

**oeldere** · 05-15-2013, 02:52 PM

Try this one.

=MATCH(B1,A1:A6,1)

**Pepe Le Mokko** · 05-15-2013, 02:52 PM

Perhaps

Please Login or Register  to view this content.

**Jonmo1** · 05-15-2013, 02:57 PM

Originally Posted by weeble33

Even the description for Match states it's able to handle logic functions.

Actually, it says it can be a logical 'value', not a logical function. Yes, there's a big difference.
Logical Values are just simply True and False.

It looks like Pepe's solution does what you want.

**Hurricanefly** · 05-15-2013, 03:00 PM

Do you want to find all the rows which are less than 50? could you post a worksheet example?

**MrShorty** · 05-15-2013, 03:04 PM

Even the description for Match states it's able to handle logic functions.

I think you've misread it. It says that it can handle logical values (eg TRUE or FALSE), not logical functions. So, if your data has a TRUE entry, it can find that, if it has a FALSE entry, it can find that.

Another observation, you have omitted the third "match_type" argument, which tells the MATCH() function that the data is sorted in ascending order. Obviously this is not the case.

I'm not sure I can make a solid recommendation, because I don't know what you are really trying to accomplish here. It looks like you want to identify all the entries that are less than 50. One thought. If you can sort the data (9;13;14;45;49;56) then do a match on that =MATCH(B1,A1:A6,1), it will return 5, which is the position of the largest value (in the sorted data set) <= 50. Now it depends on what you want to do with this information, but you have successfully located all of the values that are <=50.