Vlookup with more than one criteria

Hi,

I am trying to do a vlookup that also only returns the delivery time only if the day and customer ID are the same
In the customer tab I have a list of customers and days, and from the schedule tab I want to look for the customer and only return the time if the days match
See example below - it returns the times for customer EWM-1650 in the correct columns/days from the data held in the Transport Schedule Tab


Customer Schedule Tab

A B C D E F G H
1 Customer ID Sun Mon Tue Wed Thu Fri Sat
2 BB2003
3 BB2006
4 EWM-1650 14:15 13:30


Transport Schedule Tab

G N P
1 EWM-1650 Mon 14:15
2 EWM-1650 Wed 13:30
3 EWM-166 Wed 08:00
4 EWM-162 Fri 08:00
5 EWM-163 Thu 14:30

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

Hi,

Spreadsheet attached, thank you

Andy

Fantastic!! This works perfectly, thank you !! :-)