Excel: Fill cells with text if cells in column have specific text string


I am trying to create something that will allow me to autofill the agency column with an Agency's name if the adjacent Facility Name cell contains a certain text string. So for example, if the Facility Name is Sacramento, Union City, Ventura, Fresno, Riverside, or Cypress I want to fill the adjacent Agency cell with VIC the PICC. But if the Facility Name is Glasgow, Louisville, Westlake, etc. I want to fill the adjacent Agency cell with Access RN. I have to do this each month, so if I could find something that would be easy to apply each month, like a macro, that would be awesome. I am just not sure what the best way to go about this is, since I have multiple agencies that go with multiple facilities.

Agency Facility Name
VIC the PICC SACRAMENTO
HOUSTON


This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of September 08, 2014.


For more resources for Microsoft Excel