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