mike31z
04-30-2008, 12:36 PM
I have a problem. When I change the file to a new folder location the formula wants to reference the original file folder
I created a formula that works but in the formula if you look at the file location its E:\My Documents\TRAP\20Apr08\[TodaysTrap.xls] but I only need it to reference "TodaysTrap.xls" the actual file.
This file has a basic template and I link the certain data from "todaytrap.xls" to fill in the blanks.
I have highlighted the problem area of my formula.
=IF(ISERROR(VLOOKUP($A20,'E:\My Documents\TRAP\20Apr08\[TodaysTrap.xls]Singles'!$A$2:$K$101,2,FALSE)),"",VLOOKUP($A20,'E:\My Documents\TRAP\20Apr08\[TodaysTrap.xls]Singles'!$A$2:$K$101,2,FALSE))
Win XP
Excel 2000
Mike in Wisconsin
I created a formula that works but in the formula if you look at the file location its E:\My Documents\TRAP\20Apr08\[TodaysTrap.xls] but I only need it to reference "TodaysTrap.xls" the actual file.
This file has a basic template and I link the certain data from "todaytrap.xls" to fill in the blanks.
I have highlighted the problem area of my formula.
=IF(ISERROR(VLOOKUP($A20,'E:\My Documents\TRAP\20Apr08\[TodaysTrap.xls]Singles'!$A$2:$K$101,2,FALSE)),"",VLOOKUP($A20,'E:\My Documents\TRAP\20Apr08\[TodaysTrap.xls]Singles'!$A$2:$K$101,2,FALSE))
Win XP
Excel 2000
Mike in Wisconsin