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.

[slide]http://ultraimg.com/images/w5QK2.png[/slide]

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.)

[slide]http://ultraimg.com/images/8MXQ.png[/slide]

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.

 

[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