Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ISERROR,SMALL,INDEX, MATCH, SMALL??
=IF(ROW(A1)2,"",IF(ISERROR(SMALL($G$65:$G$69,ROW( A1))),"",INDEX($E$65:$E$69,MATCH(SMALL($G$65:$G$69 ,ROW(A1)),$G$65:$G$69,0))))
Can someone dicipher this please? Thanks, M.A.Tyler |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup/Match/Index/Small - I think | Excel Worksheet Functions | |||
Using Small | Excel Worksheet Functions | |||
Small | Excel Discussion (Misc queries) | |||
Compound Lookup, Large/Small, Match... | Excel Worksheet Functions | |||
Combo box too small! | Excel Discussion (Misc queries) |