Hi all,

I have a problem with an index function i created. Here is what the
function looks like:
*=INDEX(SMALL(C3:C782,{1;2;3;4;5}),OR(MATCH(1,A3:A 782=E7,0),MATCH(1,B3:B782=E7,0)))*

The intended purpose with it is to find the 5 smallest values from
cells C3:C782 if cells A3:A782 MATCH E7 OR if cells B3:B782 Match E7.

Hope that makes sense if not i will be happy to elaborate. At the
moment i get error #N/A with my statement.

Thanks in advance for any help,

Motty.


--
Motty
------------------------------------------------------------------------
Motty's Profile: http://www.excelforum.com/member.php...o&userid=29233
View this thread: http://www.excelforum.com/showthread...hreadid=490551