I need to lookup data in a table type data set and return it to a matrix style data set. If it was the other way around it would be easy to do with an Index(Match but I'm lost with going the other way.
In the example spreadsheet my formula would be entered in cell B2 of the 'Matrix' worksheet and would be looking up from the 'Data table' worksheet based on both the item # and color. In the case of cell B2 it would return 'COMET'.
Many TIA!
I am not exactly sure what the benefit of this layout is versus a pivot table but I would add a unique key to the left of the table (but it CAN be to the right if you want to use an index formula instead of a vlookup formula) then just an IFERROR(VLOOKUP()) as the attached file shows.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Another way.
Row\Col Blue Red Green Orange White Comet In B2 =IF(INDEX('Data table'!$B$2:$C$6,MATCH(Matrix!$A2,'Data table'!$A$2:$A$6,0),1)=B$1,INDEX('Data table'!$B$2:$C$6,MATCH(Matrix!$A2,'Data table'!$A$2:$A$6,0),2),"") Asteroid Fill down and across. Meteorite Meteor Rock
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks