![]() |
#14
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Mrkieth | Excel | 2 | 04-29-2013 07:30 AM |
![]() |
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 |