Lookup Data from two different tables and match on a third

[Gassiusmax]

I'm trying to see if excel can automatically match names from one sheet based on criteria from another sheet to a third

The first Page "Routes Previous" contains where the drivers have been before
The second page "DA Available" contains the name of the drivers available for next day
The third page "Routes - Current" is the work load for the next day.

On "Routes - Current" in column E (Highlighted yellow) I'm trying to find a formula where the list of names in "DA Available" Column B are cross referenced against the Data in "Routes Previous" and then the matched against the relevant data in "Routes - Current".

So for Example in "DA Available" the name is Daniel Lascuti, I would like the formula to search his name against the data in Routes Previous and find which postcode he has visited most (DA12 4) and then put his name next to the same post code in "Routes - Current", and producing no double names as well

If it helps I have uploaded the actual sheet through google sheets here

https://docs.google.com/spreadsheets...it?usp=sharing

Thanks in Advance

Danny

 

[Gassiusmax]

So I'm guessing this is a lost cause

 

[kilown]

you google doc did not work for me , but it sounds like a huge code and if you have not started it might be too much for "help" other than a 'do it for me' kinda thing , PM me and i will see if i can help, and lead you in the right direction.

 

[Gassiusmax]

Its more of a do I need code to do it or could formula do it, if its formula based then I can sit down and trowel through it till it works but if it most definately a VBA code based then its a full stop

 

[kilown]

you can do both.

a search fuction ( code ) would help or you could just do drop down filters .

i would love to see the sheet and if needed i could help with either , i just cant pull up the doc in google doc's ( hence the Private message - or inbox me )