VLOOKUP with two match requirements

**Russell719** · 12-23-2008, 09:36 AM

In Column A I have vessel departure dates
In Column B I have Final Destinations
In Column D I have vessel arrival dates

I am trying to get the result of column D based on matching A & B information.

My dilemma is that if I have vessels with the same departure dates going to different destinations how can I retrieve the arrival date?

I've been trying "vlookup" and "index/match" to no avail.

I've posted a sample file. If anyone has a chance to take a quick look I'd appreciate it.

**NBVC** · 12-23-2008, 09:40 AM

Try:

Please Login or Register  to view this content.

After you enter the formula, confirm it with CTRL+SHIFT+ENTER not just ENTER. You will see { } brackets appear.

**VBA Noob** · 12-23-2008, 09:43 AM

See if example helps. Added a helper column

VBA Noob

**Russell719** · 12-23-2008, 09:48 AM

Originally Posted by NBVC

Try:

Please Login or Register  to view this content.

After you enter the formula, confirm it with CTRL+SHIFT+ENTER not just ENTER. You will see { } brackets appear.

Unbelieveable - you guys are fantastic.
Thanks so much.

Just want to let you all know that I'm not just relying on others to do my work, I have been playing with formulae for two hours every morning trying to create this somewhat complex purchase order form.

The best thing of all is that I am learning alot.
Thanks again.