Hi Everyone, I am new to this forum, so this maybe a very amateur question.
I have a list of data of leads (Raw data) and it has 3 columns
Name Source Date
XYZ FB 14/4/2017
ABC FB 15.4/2017
LMG SMS 16/4/2017
LOP FB 17/4/2017
YUO SMS 20/4/2017
GMG FB 21/4/2017
SMS FB 22/4/2017
I want to apply lookup function from another set that will match with Names in the data above that has source as "FB" and exist between "14/4/2017 to 17/4/2017".
I can't tamper with the arrangement of data above using filters, as I have to put this on auto. Any help will be really appreciated
Bookmarks