In that case, you need a column to concatenate the 2 values so that vlookup
can find both at the same time.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"jlg5454" wrote:


It gives me the first match to the date. I want the exact match from
the name range with the criteria. There are four columns in this
range. First column is date, second is h3, third is something and
fourth is the data I want to return. Basically I want to lookup data
based on columns 1 and 2 matching.

Thanks


--
jlg5454
------------------------------------------------------------------------
jlg5454's Profile: http://www.excelforum.com/member.php...o&userid=30201
View this thread: http://www.excelforum.com/showthread...hreadid=499808