B
Brad E.
Hi, I have a data table where column A = Make (named MAKE), B = Model (named
MODEL), Row 1 = Model Year (named MODELYR).
On a different sheet, I have a list of miscellaneous combinations. On this
sheet, column A contains the make, B the Model and C the Model Year.
How can I get the contents from the table to be populated in column D for my
list?
I have tried SUMPRODUCT, SUMIFS and INDEX (with MATCH) functions, but
continue to get the #Value error. I have also array-entered each of the
functions.
I would like the value in D1 where MAKE=A1, MODEL=B1 and MODELYR=C1.
MODEL), Row 1 = Model Year (named MODELYR).
On a different sheet, I have a list of miscellaneous combinations. On this
sheet, column A contains the make, B the Model and C the Model Year.
How can I get the contents from the table to be populated in column D for my
list?
I have tried SUMPRODUCT, SUMIFS and INDEX (with MATCH) functions, but
continue to get the #Value error. I have also array-entered each of the
functions.
I would like the value in D1 where MAKE=A1, MODEL=B1 and MODELYR=C1.