Data Validation

  • Thread starter Thread starter msouma
  • Start date Start date
M

msouma

I am trying to validate Data with an If Statment but can't do more than
8 IF's.

Validating Cell:
=IF(L4="Whittingham.P",Pauline,IF(L4="Le
Goff.A",Alain,IF(L4="Honisett.L",Lisa,IF(L4="Witt.P",Paula,IF(L4="Souma.M",Mark,IF(L4="Antill.c",Antill.C,IF(L4="Bidwell.P",Bidwell,IF(L4="Binns.I",Ivor))))))))

Pauline being a named range for several options.*Data Validation With
IF Statment*
 
Instead of using data validation, you could use a Vlookup formula to
fill in the name. Enter the full names in one column, and the first name
in an adjacent column.

FullName FName
Whittingham.P Pauline
Le Goff.A Alain

You can name this list, e.g. NameList.

Use the Vlookup formula to return the value from the second column:
=VLOOKUP(L4,NameList,2,FALSE)
 
Back
Top