Is vlookup able to find the file refering to column's header? I need to get
data to column B. Formula below shows that source file has the same name as
column B just without extention (.xls). Now the formula should recognize B1
to find source file. Any help is much appreciated.
A B
1 Komax40-1must 05-03-05
2 0-1000 0
3 1001 - 2000 0
4 2001 - 3000 0

=VLOOKUP(A2,'[Komax40-1must 05-03-05.xls]DAILY SHT
Komax40-1must'!$A$9:$BL$25,64,FALSE)

Regards,
veljo

You could use INDIRECT, but your example suggests you want to lookup into
closed workbooks. Is this so, INDIRECT doesn't work wit closed workbooks?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"veljo" wrote in message
...
Is vlookup able to find the file refering to column's header? I need to
get
data to column B. Formula below shows that source file has the same name
as
column B just without extention (.xls). Now the formula should recognize
B1
to find source file. Any help is much appreciated.
A B
1 Komax40-1must 05-03-05
2 0-1000 0
3 1001 - 2000 0
4 2001 - 3000 0

=VLOOKUP(A2,'[Komax40-1must 05-03-05.xls]DAILY SHT
Komax40-1must'!$A$9:$BL$25,64,FALSE)

Regards,
veljo

You are right Bob,
This data has to be updated as Edit-Links-Update Values without opening
workbooks. Any further suggestions?

veljo

"Bob Phillips" kirjutas:

You could use INDIRECT, but your example suggests you want to lookup into
closed workbooks. Is this so, INDIRECT doesn't work wit closed workbooks?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"veljo" wrote in message
...
Is vlookup able to find the file refering to column's header? I need to
get
data to column B. Formula below shows that source file has the same name
as
column B just without extention (.xls). Now the formula should recognize
B1
to find source file. Any help is much appreciated.
A B
1 Komax40-1must 05-03-05
2 0-1000 0
3 1001 - 2000 0
4 2001 - 3000 0

=VLOOKUP(A2,'[Komax40-1must 05-03-05.xls]DAILY SHT
Komax40-1must'!$A$9:$BL$25,64,FALSE)

Regards,
veljo

If you are unto VBA, you could try a user defined function created by Harlan
Grove:
http://www.google.com/groups?selm=sH...wsranger. com


--

HTH

RP
(remove nothere from the email address if mailing direct)


"veljo" wrote in message
...
You are right Bob,
This data has to be updated as Edit-Links-Update Values without opening
workbooks. Any further suggestions?

veljo

"Bob Phillips" kirjutas:

You could use INDIRECT, but your example suggests you want to lookup
into
closed workbooks. Is this so, INDIRECT doesn't work wit closed
workbooks?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"veljo" wrote in message
...
Is vlookup able to find the file refering to column's header? I need
to
get
data to column B. Formula below shows that source file has the same
name
as
column B just without extention (.xls). Now the formula should
recognize
B1
to find source file. Any help is much appreciated.
A B
1 Komax40-1must 05-03-05
2 0-1000 0
3 1001 - 2000 0
4 2001 - 3000 0

=VLOOKUP(A2,'[Komax40-1must 05-03-05.xls]DAILY SHT
Komax40-1must'!$A$9:$BL$25,64,FALSE)

Regards,
veljo

Thanks Bob, but seems to me like top grade pilotage. I have used VBA but not
at this level. I am confused where to put my data on this function. If you
dont mind please explain a bit deeper.

"Bob Phillips" kirjutas:

If you are unto VBA, you could try a user defined function created by Harlan
Grove:
http://www.google.com/groups?selm=sH...wsranger. com


--

HTH

RP
(remove nothere from the email address if mailing direct)


"veljo" wrote in message
...
You are right Bob,
This data has to be updated as Edit-Links-Update Values without opening
workbooks. Any further suggestions?

veljo

"Bob Phillips" kirjutas:

You could use INDIRECT, but your example suggests you want to lookup
into
closed workbooks. Is this so, INDIRECT doesn't work wit closed
workbooks?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"veljo" wrote in message
...
Is vlookup able to find the file refering to column's header? I need
to
get
data to column B. Formula below shows that source file has the same
name
as
column B just without extention (.xls). Now the formula should
recognize
B1
to find source file. Any help is much appreciated.
A B
1 Komax40-1must 05-03-05
2 0-1000 0
3 1001 - 2000 0
4 2001 - 3000 0

=VLOOKUP(A2,'[Komax40-1must 05-03-05.xls]DAILY SHT
Komax40-1must'!$A$9:$BL$25,64,FALSE)

Regards,
veljo

--

HTH

RP
(remove nothere from the email address if mailing direct)


"veljo" wrote in message
...
Thanks Bob, but seems to me like top grade pilotage. I have used VBA but
not
at this level. I am confused where to put my data on this function. If you
dont mind please explain a bit deeper.

"Bob Phillips" kirjutas:

If you are unto VBA, you could try a user defined function created by
Harlan
Grove:

http://www.google.com/groups?selm=sH...wsranger. com


--

HTH

RP
(remove nothere from the email address if mailing direct)


"veljo" wrote in message
...
You are right Bob,
This data has to be updated as Edit-Links-Update Values without
opening
workbooks. Any further suggestions?

veljo

"Bob Phillips" kirjutas:

You could use INDIRECT, but your example suggests you want to lookup
into
closed workbooks. Is this so, INDIRECT doesn't work wit closed
workbooks?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"veljo" wrote in message
...
Is vlookup able to find the file refering to column's header? I
need
to
get
data to column B. Formula below shows that source file has the
same
name
as
column B just without extention (.xls). Now the formula should
recognize
B1
to find source file. Any help is much appreciated.
A B
1 Komax40-1must 05-03-05
2 0-1000 0
3 1001 - 2000 0
4 2001 - 3000 0

=VLOOKUP(A2,'[Komax40-1must 05-03-05.xls]DAILY SHT
Komax40-1must'!$A$9:$BL$25,64,FALSE)

Regards,
veljo

Sorry mate, I am out of time at the moment, and will be busy. If you need it
in 2 weeks still, mail me and I will help you.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"veljo" wrote in message
...
Thanks Bob, but seems to me like top grade pilotage. I have used VBA but
not
at this level. I am confused where to put my data on this function. If you
dont mind please explain a bit deeper.

"Bob Phillips" kirjutas:

If you are unto VBA, you could try a user defined function created by
Harlan
Grove:

http://www.google.com/groups?selm=sH...wsranger. com


--

HTH

RP
(remove nothere from the email address if mailing direct)


"veljo" wrote in message
...
You are right Bob,
This data has to be updated as Edit-Links-Update Values without
opening
workbooks. Any further suggestions?

veljo

"Bob Phillips" kirjutas:

You could use INDIRECT, but your example suggests you want to lookup
into
closed workbooks. Is this so, INDIRECT doesn't work wit closed
workbooks?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"veljo" wrote in message
...
Is vlookup able to find the file refering to column's header? I
need
to
get
data to column B. Formula below shows that source file has the
same
name
as
column B just without extention (.xls). Now the formula should
recognize
B1
to find source file. Any help is much appreciated.
A B
1 Komax40-1must 05-03-05
2 0-1000 0
3 1001 - 2000 0
4 2001 - 3000 0

=VLOOKUP(A2,'[Komax40-1must 05-03-05.xls]DAILY SHT
Komax40-1must'!$A$9:$BL$25,64,FALSE)

Regards,
veljo