Can I do this? =VLOOKUP(A4,D1,2,FALSE); Where D1 has "$A$4:$B$18"

S

Saravan

Required to link between two workbooks. Should be able to concatenate
different cells having the path of the second workbook. [in question - cell
D1]. Then use this path in vlookup formula.
 
S

Saravan

Hello Arno,
Thank you very much. Your solution has resolved the issue.

Thanks again.

arno said:
Hi Saravan,
- cell D1]. Then use this path in vlookup formula.
Click to expand...

you need indirect(d1) instead of just d1 for this, look in excel help
for details.

arno
Click to expand...
 
S

Saravan

To use INDIRECT function we need to have the other work book open. Is there
any other funtion that we could use to work this out, even if the excel file
is closed.

arno said:
Hi Saravan,
- cell D1]. Then use this path in vlookup formula.
Click to expand...

you need indirect(d1) instead of just d1 for this, look in excel help
for details.

arno
Click to expand...
 
Top