HLOOKUP or VLOOKUP help

[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

 

[Frank Kabel]

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)

 

[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

.

 

[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

.