Pulling information from Cell's and inputting to new cell (Newby)

Hi all,

Just looking for some advice in Excel 2010...

So I have two cells named Cell No. & Pair. What I want to happen is when I fill in the cells it will automatically populate a third field with that and more.

This changes depending on which tab im in.

So an example is below:

Im in tab 'LO4' the cell number is 01 and the pair is 02. I want the third field(hostname) to populate the following:

trhlo4slsp01a02

Please assist in the above, if you need further details please ask.

Describe ir with sample file workbook tristan

Hi, please see attached.

clientRegister.jpg

So I want the Server Column to be automatically updated given the cell and pair details, it depends what tab were on though, in this case TW1