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