Hi
Trying to use vlook up function to pull data from one workbook to another workbook.

Workbook1: Lookup Value is in B2
Workbook2:contains the table array of '[Workbook2.xlsx]Sheet1!$G$:$H$
Workbook2:Col_Index_num = 2
VLookup Range LookUp:False

Need to find match betweek wb1 b2 and wb2 G and pull the value in wb2 H over to wb1 starting in column E2 and autofill the remaining rows of column E with the value of wb2 H if match is found otherwise enter the message "no records found".



I tried this as a test but had no luck
(only did this in one workbook, just to see 


Dim Res As Variant
On Error Resume Next
Err.Clear
Res = Application.WorksheetFunction.VLookup(b2, Range("g2:h40"), 2, False)