sumproduct should work OK if you do it properly with the same length ranges,
etc. post your formula

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Brad E." wrote in message
...
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.
--
TIA, Brad E.