Afternoon all, Hoping you can help with this one I want to search a list for a set word. If found I want to pull the value from a specific cell I've attached a sample sheet as an example Thanks all Brian