VLOOKUP TABLE_ARRAY

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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...newsranger.com


--

HTH

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


"veljo" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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...newsranger.com
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "veljo" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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" <[email protected]> wrote in message
news:[email protected]...
> 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...newsranger.com
> >
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "veljo" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > 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" <[email protected]> wrote in message
news:[email protected]...
> 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...newsranger.com
> >
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "veljo" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > 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
> > > >
> > > >
> > > >
> >
> >
> >