Can someone give a working example of a VLOOKUP between 2 open workbooks? Thanks.
Can someone give a working example of a VLOOKUP between 2 open workbooks? Thanks.
Peace of mind is found in some of the strangest places.
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.
[vba]
=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)[/vba]
Peace of mind is found in some of the strangest places.