Hi

Its Ok

have resolved the problem using SumProduct

A

"Alexey" wrote in message
...
Hi is it possible to have an AND statement in a vlookup when comparing
data. For example:

VLOOKUP($A29,Sheet2'!$D$4:$E$1045,2,0) will look up where the $A29 data
of the current sheet matches the same in Sheet2!D4:E1045. However what I
need to say is where $A29,Sheet2'!$D$4:$D$1045 and Sheet2!E4:E1045 =
"Name1".

Also can someone explain what the 2,0 at the end of the vlookup stateme nt
represents.

Thanks
A