Thread: ISERROR,SMALL,INDEX, MATCH, SMALL??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M.A.Tyler M.A.Tyler is offline
external usenet poster
  
Posts: 100
Default 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
Reply With QuoteReply With Quote