Using VLOOKUP

christal · Apr 12th, 2002, 07:00 AM

On my active worksheet, I have linked to another worksheet, in another file, and used the VLOOKUP function. But I am finding that I have to have that other file open in order for the VLOOKUP function to work... otherwise my active worksheet will display #VALUE in the cell. Is this normal with EXCEL or have I done something wrong in my formula? The formula is as follows:

=SUMIF([InvAFH0104Adj0201.xls]Sched51!$D$2:$D$109,VLOOKUP($B126,'G:FH Master PlanFHMP 2002Inventory[Inventory 2002.xls]Translations'!$A$2:$C$190,3),[InvAFH0104Adj0201.xls]Sched51!$R$2:$R$109)

Any help would be greatly appreciated!

Thanks!

)

Andy Gee · Apr 12th, 2002, 07:32 AM

Make sure you update external references on opening the sheet.

Good luck

christal · Apr 12th, 2002, 08:09 AM

I will try that! Thanks!

The spreadsheets I am working with are such a mess right now, I can't update any of the links because it will throw the whole workbook off!!

Again, Thanks for your help!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 12th, 2002, 07:00 AM	#1
christal New Member Join Date: Apr 2002 Posts: 45	On my active worksheet, I have linked to another worksheet, in another file, and used the VLOOKUP function. But I am finding that I have to have that other file open in order for the VLOOKUP function to work... otherwise my active worksheet will display #VALUE in the cell. Is this normal with EXCEL or have I done something wrong in my formula? The formula is as follows: =SUMIF([InvAFH0104Adj0201.xls]Sched51!$D$2:$D$109,VLOOKUP($B126,'G:FH Master PlanFHMP 2002Inventory[Inventory 2002.xls]Translations'!$A$2:$C$190,3),[InvAFH0104Adj0201.xls]Sched51!$R$2:$R$109) Any help would be greatly appreciated! Thanks! )

Apr 12th, 2002, 07:32 AM	#2
Andy Gee New Member Join Date: Feb 2002 Posts: 48	Make sure you update external references on opening the sheet. Good luck

Apr 12th, 2002, 08:09 AM	#3
christal New Member Join Date: Apr 2002 Posts: 45	I will try that! Thanks! The spreadsheets I am working with are such a mess right now, I can't update any of the links because it will throw the whole workbook off!! Again, Thanks for your help!