B
Ben
Can the table array of an index/match type lookup reside in a separate
workbook without any problems
workbook without any problems
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Ardus Petus
Yes it can: no problem!
Didn't you try?
HTH
Didn't you try?
HTH
B
Ben
I did but I exprienced some problems with the links. Now that I know it's OK
I'll try again But I have a further question please. Can the name of the
other workbook reside in a cell in the workbook that contains the lookup
formula. If so could you please post an example of a simple Vlookup
substituting the Table Array with a reference to a cell that contains either
the full path of the array or maybe just the name of the other workbook. I
have experimented with it but I have not been successful so far.
Thanks
I'll try again But I have a further question please. Can the name of the
other workbook reside in a cell in the workbook that contains the lookup
formula. If so could you please post an example of a simple Vlookup
substituting the Table Array with a reference to a cell that contains either
the full path of the array or maybe just the name of the other workbook. I
have experimented with it but I have not been successful so far.
Thanks
B
Ben
Here is what I mean
=VLOOKUP(M5,[Copper.xls]Prices!$B$3:$Z$1892,6)
I'd like the reference to the other workbook Copper.xls to reside in a cell
a5. How should I then express this formula.
Thanks
=VLOOKUP(M5,[Copper.xls]Prices!$B$3:$Z$1892,6)
I'd like the reference to the other workbook Copper.xls to reside in a cell
a5. How should I then express this formula.
Thanks
A
Ardus Petus
=VLOOKUP(M5,INDIRECT("["&A5&"]Prices!$B$3:$Z$1892),6;FALSE)
You probably forgot to specify VLOOKUP 4th parameter.
HTH
--
AP
You probably forgot to specify VLOOKUP 4th parameter.
HTH
--
AP
Ben said:Here is what I mean
=VLOOKUP(M5,[Copper.xls]Prices!$B$3:$Z$1892,6)
I'd like the reference to the other workbook Copper.xls to reside in a
cell
a5. How should I then express this formula.
Thanks
Ben said:I did but I exprienced some problems with the links. Now that I know it's
OK
I'll try again But I have a further question please. Can the name of the
other workbook reside in a cell in the workbook that contains the lookup
formula. If so could you please post an example of a simple Vlookup
substituting the Table Array with a reference to a cell that contains
either
the full path of the array or maybe just the name of the other workbook.
I
have experimented with it but I have not been successful so far.
Thanks
B
Ben
Thanks, that helped but for the benefit of future readers it did not work
first time. I think there may be 2 slight inaccuracies in the formula
(there's a qoute mark missing after1892 and I believe the last semi colon
should be a comma. The syntax below works fine.
Thanks for your help.
=VLOOKUP(M5,INDIRECT("["&A5&"]Prices!$B$3:$Z$1892"),6,FALSE)
first time. I think there may be 2 slight inaccuracies in the formula
(there's a qoute mark missing after1892 and I believe the last semi colon
should be a comma. The syntax below works fine.
Thanks for your help.
=VLOOKUP(M5,INDIRECT("["&A5&"]Prices!$B$3:$Z$1892"),6,FALSE)
Ardus Petus said:=VLOOKUP(M5,INDIRECT("["&A5&"]Prices!$B$3:$Z$1892),6;FALSE)
You probably forgot to specify VLOOKUP 4th parameter.
HTH
--
AP
Ben said:Here is what I mean
=VLOOKUP(M5,[Copper.xls]Prices!$B$3:$Z$1892,6)
I'd like the reference to the other workbook Copper.xls to reside in a
cell
a5. How should I then express this formula.
Thanks
Ben said:I did but I exprienced some problems with the links. Now that I know it's
OK
I'll try again But I have a further question please. Can the name of the
other workbook reside in a cell in the workbook that contains the lookup
formula. If so could you please post an example of a simple Vlookup
substituting the Table Array with a reference to a cell that contains
either
the full path of the array or maybe just the name of the other workbook.
I
have experimented with it but I have not been successful so far.
Thanks
:
Yes it can: no problem!
Didn't you try?
HTH
--
AP
"Ben" <[email protected]> a écrit dans le message de [email protected]...
Can the table array of an index/match type lookup reside in a
separate
workbook without any problems
A
Ardus Petus
Thanks for the feedback
I answered your question without testing.
Semi-colon is my french locale separator.
Cheers,
--
AP
I answered your question without testing.
Semi-colon is my french locale separator.
Cheers,
--
AP
Ben said:Thanks, that helped but for the benefit of future readers it did not work
first time. I think there may be 2 slight inaccuracies in the formula
(there's a qoute mark missing after1892 and I believe the last semi colon
should be a comma. The syntax below works fine.
Thanks for your help.
=VLOOKUP(M5,INDIRECT("["&A5&"]Prices!$B$3:$Z$1892"),6,FALSE)
Ardus Petus said:=VLOOKUP(M5,INDIRECT("["&A5&"]Prices!$B$3:$Z$1892),6;FALSE)
You probably forgot to specify VLOOKUP 4th parameter.
HTH
--
AP
Ben said:Here is what I mean
=VLOOKUP(M5,[Copper.xls]Prices!$B$3:$Z$1892,6)
I'd like the reference to the other workbook Copper.xls to reside in a
cell
a5. How should I then express this formula.
Thanks
:
I did but I exprienced some problems with the links. Now that I know
it's
OK
I'll try again But I have a further question please. Can the name of
the
other workbook reside in a cell in the workbook that contains the
lookup
formula. If so could you please post an example of a simple Vlookup
substituting the Table Array with a reference to a cell that contains
either
the full path of the array or maybe just the name of the other
workbook.
I
have experimented with it but I have not been successful so far.
Thanks
:
Yes it can: no problem!
Didn't you try?
HTH
--
AP
"Ben" <[email protected]> a écrit dans le message de
[email protected]...
Can the table array of an index/match type lookup reside in a
separate
workbook without any problems