Thread: [Solved] Editing the text a formula gets me
View Single Post
 
Old 02-04-2016, 09:10 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Just split your vlookup into parts and concatenate. For the first one, have one vlookup grab text in the first column and then another to grab the time. Then your formula for wakeup will be...

=VLOOKUP(B2,Data!$A$1:$C$5,2,FALSE) & VLOOKUP(B2,Data!$A$1:$C$5,3,FALSE)

Sleep will be similar. The meals, since the variable data is in the middle, requires 3 vlookups.
Reply With Quote