Hi,
I have what I think is a slightly unusualy use for a Vlookup.
I have a spreadsheet with the following 3 columns (simplified): PO, Mfr Part Code & Due date.
I then have another spreadsheet with the following: PO, Mrf Part Code & Working Days.
Spreadsheet 1 is a big sheet with lots of entries. One PO can contain lots of different Mfr part codes and the Mfr Part codes can also be found on other POs. It could even come to pass that a Mfr Part code might appear twice for one PO (if a qty is increased a new line is added to the sheet).
What I want to do is do a vlookup to find the instances where the PO and Mfr part code match, then copy over the due date to spreadsheet 2 and then calculate how many working days (on spreadsheet 2) between today's date and the imported due date.
If this is the kind of thing which is explained better with uploads  I am happy to provide. I have tried Googling to no avail.
THANKS in advance.
Vlookup / networkdays required



Re: Help with Interesting vlookup / networkdays required  please.
You're right; a sample sheet is going to be a must here. As always, remove/change any proprietary data and provide a separate sheet with what the expected outcome should be.

Re: Help with Interesting vlookup / networkdays required  please.
Thank you! I have produced the following example.

Re: Help with Interesting vlookup / networkdays required  please.
Hi,
Try
=LOOKUP(2,1/((Source!$A$2:$A$26=A2)*(Source!$B$2:$B$26=B2)),Source!$C$2:$C$26)
HTH

Re: Vlookup / networkdays required
Ooops  I got an infraction for a dodgy thread title! Ho hum.
Thanks very much for your suggestion, krish, but I get #N/A when I try that? 

Re: Vlookup / networkdays required
Hi,
Quotebut I get #N/A when I try that?
That means there is no match. Check if there is any trailing or leading space either in data values or in criteria.

Re: Vlookup / networkdays required
I don't get #N/A when I use Kris' formula on your sample...but there are some strange results because you have rows where the date column is blank  what should happen then  what result do you expect. Also what about the situations when there are 2 or more matches, which date would you want. Is it the latest date?
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!