Excel help needed please

[Ashleyuk1984]

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 24th Sep 2012. 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

[Gaurav]

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

under SEC FXT row, try this formula:

=IF(A1="FELIXSTOWE", 'OtherSheetName'!CellName, "")

and repeat for cells under SEC THP and the remaining ones substituting FELIXTOWE with whatever you want

[Ashleyuk1984]

superb, done exactly what i wanted. thanks!

[Gaurav]

glad I could help