Vlookup can't take multiple criteria. You could create a helper column with
the criteria columns concatenated (in K9, for instance: =I9 & "-" & D9) and
lookup the concatenated values. Or check
http://www.xldynamic.com/source/xld.SUMPRODUCT.html to see how the sumproduct
function might help.

"Serge" wrote:

Can you enter multiple values in the "Lookup_Value". I have 3 worksheet, on
sheet 1, I have cell J9 that looks at I9 and a data table on sheet 3 which
works ok for now, but the results in J9 must be in conjunction with I9 & D9.
Can anyone help with this request.
Thanks in advance for reading my posting.