I've been searching the last few hours trying to figure this out. I know how to use vlookup to compare one column with another and return a value, but i'm struggling to compare 2 columns with 2 others at the same time and return a value.
I have two sheets.
Sheet one contains 17000 entries with Location, Date, Job Number information.
Sheet two contains 600 entries with Location, Date, and Job Task information.
Basically i need the Job Number from sheet 1 on sheet 2.
The issue is, we will have visited the same location on multiple occasions and these would have a different job number, so i need to ensure the correct number is applied to each visit.
I've attached a small example.
It will probably turn out to be something really simple and i'll be kicking myself later...
Bookmarks