vlookup

A

Alexey

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP -- Table Array Problem 1
Problems using a variable as a Table_Array in VLOOKUP 1
First column of range in VLOOKUP contains formula 2
VLookup returns value in first row 0
Vlookup-Doesn't return values under 1 1
Problem Returning Mulitple Lookup Values 1
Vlookup help 5
VLOOKUP - Multiple cells in lookup value 1

Top