NWalsh3000
New Member
- Joined
- Aug 5, 2015
- Messages
- 10
Hello, Hoping someone can help me figure this out. My Lookup function only works when the source woorkbook is open. I would like to get it to work without opening the source files.
Here is my formula when the source workbook is open
=LOOKUP(D5,'[BT Price Guide.xlsx]Mt Liq Pricing'!A:A:'[BT Price Guide.xlsx]Mt Liq Pricing'!C:C)
When the source workbook is open this formula works.
Here is my formula when the source workbook is closed
=LOOKUP(D5,'X:\bigskyf&b\ZZ BEVERAGE TRACKER TEST ZZ\[BT Price Guide.xlsx]Mt Liq Pricing'!A:A:'X:\bigskyf&b\ZZ BEVERAGE TRACKER TEST ZZ\[BT Price Guide.xlsx]Mt Liq Pricing'!C:C)
it returns #ref
how can I fix this?
Thank you!
Here is my formula when the source workbook is open
=LOOKUP(D5,'[BT Price Guide.xlsx]Mt Liq Pricing'!A:A:'[BT Price Guide.xlsx]Mt Liq Pricing'!C:C)
When the source workbook is open this formula works.
Here is my formula when the source workbook is closed
=LOOKUP(D5,'X:\bigskyf&b\ZZ BEVERAGE TRACKER TEST ZZ\[BT Price Guide.xlsx]Mt Liq Pricing'!A:A:'X:\bigskyf&b\ZZ BEVERAGE TRACKER TEST ZZ\[BT Price Guide.xlsx]Mt Liq Pricing'!C:C)
it returns #ref
how can I fix this?
Thank you!
Last edited: