Hello friends,
I have a spreadsheet that aim to collect information of technical assistance that my company offer to different health agencies. Some of the fields we have in the spreadsheet include staff person name, type of services provide, duration of the services, agency name, agency ID. I create a drop down many for Agency ID so staff who are offering the service can select a valid agency ID. I need to automatically have the name of the agency associate with the agency ID as well as its State. So if I select Agency 100, the agency name cell will automatically be filled with the corresponding name of that agency (see attached). Or if I know the agency name the Agency ID, the name of the agency will fill automatically. Is there a way to do this?
I will greatly appreciate any help and suggestion.
GRacias,
MArvin
Bookmarks