Hi,

You don't tell us your data layout so this assumes

Col A Col B Col C
Name Start End

Put this in a cell
=IF(VLOOKUP(INDEX(A:A,MATCH(REPT("z",10),A:A,1),1) ,A1:C6,3,FALSE)=0,"Another
placement still current","")

The formula has wrapped as I pasted it but it all goes in a single cell.
Every time a new name is added to column A it will look for another instance
of that name and check if column C is blank and if it is it will display your
warning. Ir always checks the last entry in column A so there is no need to
alter the formula when a new name is added.

Mike

"Janelle S" wrote:

Hi all
Hoping you can help out? I have a list of names with start and end date (of
placement). When I enter a new entry I want to be able to identify if a
previous entry does not have an end date and then a warning pops up for the
user saying something like "another placement still current".
Thanks in anticipation.