I need to start at D600 and go up D column looking for "St Louis". Once it is located put "GP01" in the next empty cell.


So if
D89 = "Atlanta"
D88 = "St Louis"
D87 = "Henry"
D86 = "Vehicle"
D85 = ""
D84 = "Canada"

The D85 would now equal "GP01