VLOOKUP and links to another workbook\tab

[Guest]

I have mutliple tabs in a worksheet that I need to reference from another file. I would like the "tab" portion of the table_array to be a variable on the input worksheet. I've gotten close (I think)

=VLOOKUP(C14,'C:\Documents and Settings\eddiem\My Documents\Billing Information\[Billing rates - Master.xls]\["& h3"]!$A$7:$C$24,2,FALSE)

 

[Peo Sjoblom]

Won't work, the other workbook has to be open.. For a possible solution

http://google.com/[email protected]

--

Regards,

Peo Sjoblom

I have mutliple tabs in a worksheet that I need to reference from another

file. I would like the "tab" portion of the table_array to be a variable on
the input worksheet. I've gotten close (I think):

=VLOOKUP(C14,'C:\Documents and Settings\eddiem\My Documents\Billing

Information\[Billing rates - Master.xls]\["& h3"]!$A$7:$C$24,2,FALSE)

 

[Guest]

I have the ability to have both files open.

Eddie

----- Peo Sjoblom wrote: ----

Won't work, the other workbook has to be open.. For a possible solutio

http://google.com/[email protected]

--

Regards

Peo Sjoblo

I have mutliple tabs in a worksheet that I need to reference from anothe

file. I would like the "tab" portion of the table_array to be a variable o
the input worksheet. I've gotten close (I think)Information\[Billing rates - Master.xls]\["& h3"]!$A$7:$C$24,2,FALSE

 

[Peo Sjoblom]

Then you can use indirect for a cell address that is a variable
something like

=VLOOKUP(C14,INDIRECT("'"&H3&"'!A7:C24"),2,FALSE)

adapt to fit your workbook

--

Regards,

Peo Sjoblom

I have the ability to have both files open.

Eddie


----- Peo Sjoblom wrote: -----

Won't work, the other workbook has to be open.. For a possible solutionhttp://google.com/groups?threadm=oZxYa.14760%24cJ5.1412%40www.newsranger.com

--

Regards,

Peo Sjoblom

I have mutliple tabs in a worksheet that I need to reference from

another
file. I would like the "tab" portion of the table_array to be a variable on
the input worksheet. I've gotten close (I think): Documents\Billing
Information\[Billing rates - Master.xls]\["& h3"]!$A$7:$C$24,2,FALSE)

 

[Guest]

THANKS!