refer to other xls file

D

DKY

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 ho
do I make this take from the "CURRENT INVENTORY PRICING.xls"
 
F

Frank Kabel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate end date and time 1
trouble with (complicated) vlookup searching another workbook 2
Can you auto edit file names inside a formula 2
Find last date of sold stock and sold price. 2
Lookup functions always return n/a ??? 3
Horizontal and Vertical lookup 2
Alternative of Vlookup function which improves speed 4
VLookup Won't Copy down (#REF! error) 1

Top