Pedro Morais
Board Regular
- Joined
- Dec 5, 2007
- Messages
- 90
Hi guys,
I've been using INDIRECT.EXT and VLOOKUP and been facing problems with sum of the formulas, as some work perfectly and some only work with the other workbook open.
Works perfectly:
VLOOKUP($N$2,INDIRECT.EXT("'T:\Agent Performance\Portugal\[Portugal Coll "&O1&" - Agent Performance.xls]Monthly'!$B$4:$AW$30"),15,FALSE)
Only works with the other workbook open:
VLOOKUP($N$2,INDIRECT.EXT("'T:\Teams\2008\"&$N$1&"\["&$P$2&"''s Team "&Sheet1!$A$5&".xls]"&$Q$2&"'!b4:ah37"),9,FALSE)
I can´t seem to see a pattern and the link is good, cos i´ve checked and checked again and besides it wouldn´t work when the other workbook is open (which it does).
Can anyone help please?
Thanks
Pedro
I've been using INDIRECT.EXT and VLOOKUP and been facing problems with sum of the formulas, as some work perfectly and some only work with the other workbook open.
Works perfectly:
VLOOKUP($N$2,INDIRECT.EXT("'T:\Agent Performance\Portugal\[Portugal Coll "&O1&" - Agent Performance.xls]Monthly'!$B$4:$AW$30"),15,FALSE)
Only works with the other workbook open:
VLOOKUP($N$2,INDIRECT.EXT("'T:\Teams\2008\"&$N$1&"\["&$P$2&"''s Team "&Sheet1!$A$5&".xls]"&$Q$2&"'!b4:ah37"),9,FALSE)
I can´t seem to see a pattern and the link is good, cos i´ve checked and checked again and besides it wouldn´t work when the other workbook is open (which it does).
Can anyone help please?
Thanks
Pedro