VLook-UP using VBA - across multiple workbooks

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)

Thanks Trevor Ill give a shot

Hey Trevor,
How could I modify this so to autofill column E with the results. Also If #N/A is the returned value how to I change this to equal "!! N0 B2B Status Found !! in dark blue.

Bob

Thanks Trevor - I uploaded the two files -- Thanks again -Really be glad to close this project learned alot though. Appreciate your support

Hi Trevor
Are you saying you didn't see them .. Thought I sent as attachments.. What is the best way to get them to you..

Hi Trevor,
Uploaded the files again. Sorry for that it appears one was too large last night.

Thanks again for your time and for your patience on this.

Bob

Hi Trevor,
I checked Manage Attachments and I see them there. I am not sure I understand why you are not seeing them.

I will use a manual technique for the vlook up which I was hoping to avoid .






Bob

Hi Trevor
Any luck seeing the files ?