Is it possible to Auto Populate column B based on content in Column A?

Christi Jones

If Column A is "Mark" - Colunm B would automatically populate with "HR"

If Column A is "Mark" and "John" - Colunm B would automatically populate with "HR" and "Sales"

The idea is for column B to populate automatically with department name, based on individual identified

markkrebs

Yes, This will give you a start. =IF(CONTAINS("Mark", A@row), "HR ") + IF(CONTAINS("John", A@row), "Sales ")

If the And is needed then you'll need to make a modification

Christi Jones

Thanks @markkrebs - Ill give it a try this afternoon.