|
|
|
|
#1
11-03-2015, 03:38 AM
|
||||
|
||||
From what you've posted I think you'd need to use:
=VLOOKUP(P2,INDIRECT("'[2015 Cordell Valuation Lookup Tables.xlsx]"&BK2&"'!$A:$I"),5,FALSE) On a side note, if you add worksheets to your existing workbook to pull in the data from your '2015 Cordell Valuation Lookup Tables' workbook, you could reduce the formula to: =VLOOKUP(P2,INDIRECT("'"&BK2&"'!$A:$I"),5,FALSE) That, in turn, means you wouldn't need to have your '2015 Cordell Valuation Lookup Tables' workbook open for the calculations to work.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Would like to return a row rather than a cell using VLookup | canajun | Excel | 7 | 12-10-2014 01:03 PM |
| VLOOKUP looking at another cell for its range | Rich18144 | Excel | 1 | 06-24-2014 07:56 AM |
 trying to use vlookup to calculate several different situations in one cell
|
heastlund | Excel | 3 | 11-21-2013 12:38 PM |
| Choose your footer? | KenZu | Word | 9 | 03-08-2012 01:40 AM |
| need help with a forumula | bigbosky32 | Excel | 1 | 11-07-2008 03:15 PM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode