PDA

View Full Version : VLOOKUP Between workbooks



austenr
02-12-2013, 12:36 PM
Can someone give a working example of a VLOOKUP between 2 open workbooks? Thanks.

austenr
02-12-2013, 12:58 PM
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)