I have a spreadsheet which was created by a predecessor (so I cannot ask them), it has multiple drop down menus, but no tab with data lists to show where these are pulled from, that I can see of. I need to edit the drop down menus to include some more options, it looks like a lookup is in place. The formula is =Lookups!$A$3:$A$17 . How do I go about editing this to allow further drop list options?  

​I have a spreadsheet which was created by a predecessor (so I cannot ask them), it has multiple drop down menus, but no tab with data lists to show where these are pulled from, that I can see of. I need to edit the drop down menus to include some more options, it looks like a lookup is in place. The formula is =Lookups!$A$3:$A$17 . How do I go about editing this to allow further drop list options?    Read More

​