vlookup 2 columns

  • Thread starter Thread starter Rajkumar
  • Start date Start date
R

Rajkumar

Hi,

I have in sheet1 data like this,just eg :-

Ord Part Date
890 123 01/02/2004
900 123 01/17/2004
900 492 01/17/2004
914 123 01/20/2004

But when i do vlookup in sheet2 the date column looks like this.
=vlookup(b2,sheet1$a$2:$b$4,2,false)

Ord Part Date
890 123 01/02/2004
900 123 01/02/2004
900 492 01/17/2004
914 123 01/02/2004

While vlookup,the date column takes the first DATE occurance for the
part.

I want to compare both the part no as well as order no while doing
vlookup.

I need something like =vlookup(Order no) & vlookup(partno)

Result should be in sheet2:
Ord Part Date
890 123 01/02/2004
900 123 01/17/2004
900 492 01/17/2004
914 123 01/20/2004

Thanks in advance
Rajkumar:p
 
Hi

=SUMPRODUCT((sheet1$a$2:$A$4=a2)*(sheet1$b$2:$b$4=b2)*(sheet1$c$2:$c$4))
and format as date
 
Back
Top