View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Unable to get examples to work for lookup etc

Oops, correction to description. Lines:
In C2:
=IF(ROW(A1)COUNT(E:E),"",INDEX($A:$A,MATCH(SMALL( E:E,ROW(A1)),E:E,0)))
In D2:
=IF(ROW(B1)COUNT(F:F),"",INDEX($A:$A,MATCH(SMALL( F:F,ROW(B1)),F:F,0)))


should simply read as:
In C2:
=IF(ROW(A1)COUNT(E:E),"",INDEX($A:$A,MATCH(SMALL( E:E,ROW(A1)),E:E,0)))
Copy C2 to D2


(The formula in D2 is just a sweet copy across of the one placed in C2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---