Excel 2007 : Index Function Array Filtering

**RowanB** · 02-26-2010, 10:19 AM

Hi,

Forgive me for being ignorant of forum etiquette if I am being rude, but please could you help me with the following?

It would probably be superfluous to explain the full context of what I'm trying to do, so basicaslly, I would like to know how to make the following function apply, not just to numbers below and equal to 40147, but also above a certain value:

MATCH(TRUE,INDEX('Nov Collections'!A2:A$234<=40147,0),0),"")

The above function works, but the following doesn't:

MATCH(TRUE,INDEX(23>='Nov Collections'!A2:A$234<=40147,0),0),"")

I thought that would return the first value between 23 and 40147 inclusively, but it produces an error.

Help greatly appreciated.