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

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


Luong wrote:
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

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


Luong wrote:
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

.

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

--
Regards
Frank Kabel
Frankfurt, Germany


Luong wrote:
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


Luong wrote:
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

.