Thread: [Solved] Can I use vlookup to choose what forumula to use in a cell?
View Single Post
 
Old 11-03-2015, 03:58 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
The ampersand (&) joins the expression preceding it with the one following it. With:
"'[2015 Cordell Valuation Lookup Tables.xlsx]"&BK2&"'!$A:$I"
there are thus three expressions being joined:
• "'[2015 Cordell Valuation Lookup Tables.xlsx]"
• BK2
• "'!$A:$I"
The first and last of these are literal strings; the second one retrieves the contents of BK2. So, if BK2 contains 'Data type 1', you end up with a VLOOKUP formula referencing:
"'[2015 Cordell Valuation Lookup Tables.xlsx]Data type 1'!$A:$I"
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote