HLOOKUP or VLOOKUP help

L

Luong

Hello,

can you do a HLookup or VLookup from another Excel file?
if so, what is the command?

I have an excel file with drop down list of part number
from the cell. The part number on the drop down list
depend on another Excel file. Thanks
 
L

Luong

Frank,
Thanks for your help, but I got one more question.
The file (c:\temp\[book1.xls]sheet1') file is different
each time. They are located in different folder on the
network and I have to do this for 50 rows. How can I
automate this so I don't have to type the file directory
50 times. Thank

-----Original Message-----
Hi
for the drop-down issue see http://www.contextures.com/xlDataVal05.html

For using a separate workbook/worksheet within VLOOKUP. No problem.
e.g.
=VLOOKUP(A1,'c:\temp\[book1.xls]sheet1'!$A$1:$B$100,2,0)


--
Regards
Frank Kabel
Frankfurt, Germany

Hello,

can you do a HLookup or VLookup from another Excel file?
if so, what is the command?

I have an excel file with drop down list of part number
from the cell. The part number on the drop down list
depend on another Excel file. Thanks
Click to expand...

.
Click to expand...
 
F

Frank Kabel

Hi
not really possible as I assume your other files are closed
-> INDIRECT won't work

--
Regards
Frank Kabel
Frankfurt, Germany

Frank,
Thanks for your help, but I got one more question.
The file (c:\temp\[book1.xls]sheet1') file is different
each time. They are located in different folder on the
network and I have to do this for 50 rows. How can I
automate this so I don't have to type the file directory
50 times. Thank

-----Original Message-----
Hi
for the drop-down issue see http://www.contextures.com/xlDataVal05.html

For using a separate workbook/worksheet within VLOOKUP. No problem.
e.g.
=VLOOKUP(A1,'c:\temp\[book1.xls]sheet1'!$A$1:$B$100,2,0)


--
Regards
Frank Kabel
Frankfurt, Germany

Hello,

can you do a HLookup or VLookup from another Excel file?
if so, what is the command?

I have an excel file with drop down list of part number
from the cell. The part number on the drop down list
depend on another Excel file. Thanks
Click to expand...

.
Click to expand...
Click to expand...
 
Top