Make List from Match in Table
Hi guys,
On Sheet1 I have a list of products in row A, with all of the ingredients in the rows below.
In Sheet 2 I have a list of ingredients in row A.
I would like a list of matching products to appear below each ingredient, if it is an ingredient used for that product.
Any help is greatly appreciated, I can't figure it out!
Note - I have made sure that all the ingredient names are identical to the first row in Sheet2.
Many thanks,
Danny
In A2, copied across and down:
=IFERROR(INDEX('Menu Items'!$1:$1,AGGREGATE(15,6,COLUMN('Menu Items'!$A$2:$AR$20)/('Menu Items'!$A$2:$AR$20=A$1),ROWS(A$2:A2))),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks