Assuming A1 to be the coulmn where you enter FELIXSTOWE or THAMESPORT try this:

under SEC FXT row, try this formula:

Code: 
=IF(A1="FELIXSTOWE", 'OtherSheetName'!CellName, "")
and repeat for cells under SEC THP and the remaining ones substituting FELIXTOWE with whatever you want
Gaurav Reviewed by Gaurav on . Excel help needed please Hi, My mind has gone totally blank and I cant figure out how to do this. I will try to explain this as simply as I can, also with screenshots. When a certain cells value has been inputted, depending on that information another cell is completed. But if the original value is different, then a different cell is completed. For example. When I input "Felixstowe", it fills in the value (which is dragged from another sheet) in the "SEC FXT" box. Rating: 5