LinkBack URL
About LinkBacks
If you index the entire column then you don't have to mess with an offset correction.
=IFERROR(INDEX('Sale Sheet'!$A:$A,SMALL(IF('Sale Sheet'!$D$2:$D$69=$C$11,ROW('Sale Sheet'!$D$2:$D$69)),ROWS($A$1:A1))),"")
If you index the entire column then you don't have to mess with an offset correction.
=IFERROR(INDEX('Sale Sheet'!$A:$A,SMALL(IF('Sale Sheet'!$D$2:$D$69=$C$11,ROW('Sale Sheet'!$D$2:$D$69)),ROWS($A$1:A1))),"")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks