VLOOKUP Between workbooks

[austenr]

Can someone give a working example of a VLOOKUP between 2 open workbooks? Thanks.

[austenr]

I came up with this but it gives an error. The lookup tries to find a match between two columns in 2 different workbooks and if so then I need to return Col A of the workbook being searched to Col G of the destination workbook or in this example G109.


=VLOOKUP(G109,'[Server count by wave 09-04-2012.xlsx]Server Count 2013'!$F$3:$F$1274,'[Server count by wave 09-04-2012.xlsx]Server Count 2013'!$A$1:$A$1274)