dynamic vlookup from one workbook to another and autofill

Hi,

I am stucked at this place. I am trying to do vlookup between two workbooks.

I need to do vlookup in column S2 of one workbook.
look value is column Q2
table array is in another workbook (C:\Users\aman.bhardwaj\Desktop\Ideas\Learning process\30th November 2015\AIL RFL\LearnersinMandateDataExport_EMEIA_RFL.xls") - PLEASE CONSIDER THIS WORKBOOK AS OPEN. ALSO IF NOT OPEN THEN CODE HAS TO OPEN IT FROM THE GIVEN LOCATION.

table array in another workbook is - P:Q
column index number - 2

Below is my code. Please help

Please Login or Register  to view this content.