|
|
#2
02-04-2016, 09:10 AM
|
|||
|
|||
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. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| formatting consistency | drofla | Word | 2 | 06-03-2015 10:53 PM |
 editing content for visual consistency
|
eNGiNe | PowerPoint | 3 | 03-31-2015 12:31 PM |
|
Maintaining Consistency across multiple documents
|
Yann | Word | 1 | 04-19-2012 08:07 PM |
| Vertical lines | nigo75 | Project | 3 | 09-13-2011 04:03 AM |
| Vertical | climberman | Word | 2 | 12-29-2009 09:53 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode