Is it possible to have vlookup and data validation in the same cell(drop down list )I want to be able to use vlookup as the main source of data entry but also be able to override it if I have to with a drop down list through Data validation.Can I do this without using VB.My vlookup formula is =IF(A13="","",VLOOKUP(A13,WORKERS,4,0)) My data Validation is = title.Thanks in advance.
Bookmarks