Thread: [Solved] Can I use vlookup to choose what forumula to use in a cell?
View Single Post
 
Old 11-03-2015, 03:38 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,363
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote