Vlookup

[Calibre16]

Hi,

Help Please.

I have two separate workbooks, Workbook A & Workbook B.
In both workbooks, I have two columns (G & H) where a series of codes are entered in, but not in order. For example:
Workbook A: G3 = D12332 & H3 = 1
Workbook B: G17 = D12332 & G17 = 1

What is the formula for:

If the data in Workbook A, G:G & H:H matches to that of Workbook B, G:G & H:H then populate cell AW in Workbook A with the corresponding data in cell AW Workbook B
If the data doesn't match, then populate AW Workbook A with N/A


Please note that the data in G:G & H:H in both workbooks is not alligned by row number. they are scattered.

Thanks,

Cal16

 

[SpillerBD]

=IFERROR(VLOOKUP(G1,[WorkBook_A.xlsx]Sheet1!$G:$H,2,FALSE),"N/A")