On Mar 18, 1:21*pm, Pete wrote:
In col A, starting at A3 have a list of customer names.
The columns B1:E1 are labeled 1,2,3,4 respectively, indicating option
numbers.
In Columns B2:E2 is the Product ID (which are identical in this group
of four). *There are over 100 product ID's, each with options
available of 1,2,3 or 4.

Need to specify on another worksheet the customer located in col. A,
the option desired from row 1, (1,2,3 or 4) and the product ID from
row 2. *Need to retrieve the value located within the table.
So, if a certain customer choses the product ID, with an option of 3,
it would retrieve the proper amount.

Tried retrieving with the numerical data with SUMIFS, but it did not
work. *Perhaps a varient of SUMPRODUCT?
Thanks for pointing me in the right direction.
Pete

Easier if I see the actual file with before/after. send to
. Notice the 1