I have a spreadsheet for recording staff holidays but some staff hold key
positions where cover is needed if that individual is off. The names are
entered by two admin staff as holidays are requested but they don't always
know for which staff cover is needed. To make this easier i would like to add
a function whereby the spreadsheet displays a message along the lines of
'cover is required for this position' when a particular name is entered. Each
cell in Row A has a drop down list of names from which to select.
Any help would be appreciated.

Thanks