vlookup 2 columns

[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

 

[Arvi Laanemets]

Hi

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

 

[Andy]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/vlookup2.zip
It's in the "Worksheet" section on page:
http://www.bygsoftware.com/examples/examples.htm

Look up on two fields with this alternative to VLOOKUP


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"