Data Populating

Afternoon:

Have a issue with a excel file i will do my best to explain.

What i am trying to do is simply this - Have two columns with a range of rows, First column, any row can contain any of the following words -

fault, referred, maintenance, riser, 6UDrop, 11UDrop, Minor, Connectors, Temp

In the next column in the same row, the proper code must show up -

S1, S2, S3, S4, S5, S6, S7, S7, S8

Any Help would be very welcome, if you have any questions please let me know.

Thanks

Steve

Here is a example, i hope this answers your question

Steve

Hi,

I think thet you need to write in cell M2 the formula:
="S"&ROW()-1
and copy down.

did i understand correctly ?
kori

Thank you but no this is not correct. Please let me know if i can explain different.

Thanks again

Steve