|
|
#14
05-12-2013, 11:18 AM
|
|||
|
|||
Hi Tony
That works a treat. If at some point I need to change the Occupancy layout at a future date, would applying the formula =IF(ISERROR(VLOOKUP(C3,'FRONT SHEET'!$C$5:$D$25,2,FALSE)),"Empty",VLOOKUP(C3,'FR ONT SHEET'!$C$5:$D$25,2,FALSE)) and changing the cell details be sufficient. The reason I ask is to a) grasp what you actually did, to learn from you b) a colleague is most likely to ask me to set the same up for the ward next door which is of a different floor plan 
|
| Tags |
| auto, cell |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Populate Data to another cell
|
Mrkieth | Excel | 2 | 04-29-2013 07:30 AM |
|
how do I auto-populate a word template
|
Greenhorn | Word | 4 | 09-05-2012 04:16 PM |
| Auto populate text | help i'm stuck! | Word | 1 | 08-13-2010 11:52 AM |
| auto populate to a PDF file | jerrymbna22 | Excel | 0 | 07-12-2010 02:19 PM |
| Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode