Hi,
Hopefully one of you clever people will be able to help (again) - via a formula I wish to populate the yellow cells in this sheet from the list on the other one based on the code in A1 on the first sheet. There will be multiple different suppliers based on the one code in cell A1.
Many thanks in advance
Suzanne
This array formula** entered in A4:
=IFERROR(INDEX(Sheet1!B:B,SMALL(IF(Sheet1!A$2:A$20=A$1,ROW(Sheet1!A$2:A$20)),ROWS(A$4:A4))),"")
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Copy down until you get blanks.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
That is amazing Tony!
Thank you so much - I've learnt something new - I had no idea about array formulas. What makes them different?
It works btw - I will just adapt to the source document.
Suzanne
See if this helps...
http://www.cpearson.com/Excel/ArrayFormulas.aspx
Thanks - I shall read in the morning as I think my head will explode right now - its been a long day!
Thank you once again for your help.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks