Could someone look at this spreadsheet. I have multiple products in a drop down list that have the same name because they have different sizes, but when I choose one it will only populate the data from name that is first on the list? I can't get the second of the duplicate names in the drop down menu to populate it's corresponding data.
Last edited by ssa9320; 10-03-2008 at 04:15 PM.
A Pivot table allows you have to first consolidated the data per Product.
Then using lookup on this pivot table, you have your test ok.
See attached where in red you have your original and my changes.
Good luck
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks