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.



Now, when I input "Thamesport", I want the spreadsheet to fill in the "SEC THP" box. (and leave the other three SEC FXT / SEC STN / SEC TIL blank.)



How can I do this??
Same applies with SEC STN & SEC TIL.
(Don't worry about the #N/A in the second screenshot.)

I hope this makes sense. Thanks for your help.
Ashleyuk1984 Reviewed by Ashleyuk1984 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