Thread: [Solved] Can I use vlookup to choose what forumula to use in a cell?
View Single Post
 
Old 11-03-2015, 02:07 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
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
I'm not really following what you're doing here. I gather that in column P you have values like:
Data type 1
Data type 2
etc.

But, if your VLOOKUP:
=VLOOKUP(P2,'[different workbook.xlsx]Data type 1'!$A:$I,5,FALSE)
is referencing P2, that seems to be saying you're looking for a match with 'Data type 1' on '[different workbook.xlsx]Data type 1'. In other words, the equivalent of:
=VLOOKUP("Data type 1",'[different workbook.xlsx]Data type 1'!$A:$I,5,FALSE)


PS: For a demo of INDIRECT's use in conjunction with the OFFSET function (not necessarily relevant to your specific needs), see: https://www.msofficeforums.com/excel...reference.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote