Introduction
There was a question on Facebook the other day in which the OP wanted to know how he could find the price of an item given the product name of the item and its size. The data were in a matrix style range with the product name in the left hand column and the sizes across the top: as in the screenshot below.
There were many useful answers to this question and they all seemed to work but, in my opinion, they were rather complicated so I offered this solution, which is neater and more succinct.
Question and Answer
Read down column H to work through my solution.
Piece of cake, really but the wonder is the INDIRECT() function!
Download the Excel file from here
Duncan Williamson
3rd April 2022
No comments:
Post a Comment