Thread: Can these look ups be done using Worksheets functions
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
  
Posts: 5,441
Default Can these look ups be done using Worksheets functions
Bob,

?

Array entering

=INDEX(B1:B7,(SMALL(IF(A1:A7=D1,ROW(A1:A7)),2)))

instead of

=INDEX(B1:B7,(SMALL(IF(INDEX(A1:A7=D1,0),ROW(A1:A7 )),2)))

works fine for me.

Bernie


"Bob Phillips" wrote in message
...
It doesn't work if you don't does it?

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Bob,

Why do you use this in the middle

IF(INDEX(A1:A7=D1,0),ROW(A1:A7))

rather than just

IF(A1:A7=D1,ROW(A1:A7) ?
\


Reply With QuoteReply With Quote