refer to other xls file
 

I have this formula.

=IF(A4<"",VLOOKUP(B4,CURRENT!$A$2:$C$1647,3,FALSE )*(A4),"")

it takes information from another sheet. the "CURRENT" sheet, but how
do I make this take from the "CURRENT INVENTORY PRICING.xls"?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=318873

Hi
- open both files
- select the range with your mouse from the other file/sheet

--
Regards
Frank Kabel
Frankfurt, Germany

"DKY" schrieb im Newsbeitrag
...

I have this formula.

=IF(A4<"",VLOOKUP(B4,CURRENT!$A$2:$C$1647,3,FALSE )*(A4),"")

it takes information from another sheet. the "CURRENT" sheet, but how
do I make this take from the "CURRENT INVENTORY PRICING.xls"?


--
DKY
---------------------------------------------------------------------
---
DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
View this thread:
http://www.excelforum.com/showthread...hreadid=318873