Using v-lookup I am finding when there are multiple items with the same # entry (in this case it happens to be part numbers) the quantities returned (which is what i am trying to fill in) only fill from the first match. I have attached an example. Is there a way to have the correct quantities fill the correct line entries and part #?
Try this Array Formula. Since this is an array formula so you need to confirm it with Ctrl+Shift+Enter instead of just Enter.
In B2
and copy down.
Please Login or Register to view this content.
Is this what you are trying to achieve?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Try this...
Entered in B2 and copied down as needed:
=IFERROR(INDEX('info pull'!B:B,AGGREGATE(15,6,1/('info pull'!A$2:A$6=A2)*ROW('info pull'!A$2:A$6),COUNTIF(A$2:A2,A2))),"")
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks