Associate
hi all, what i want to do is create a drop box with many different names in it (this i can do), but when i use the drop box to select a specific name i want the cell next to it to auto enter a number that is specific to that name i.e. the persons age, any idea what formula to use?