IF a cell is a certain value, this cell should display 'x'

[NickPDC]

Hi guys!

Having a little problem with trying to get a function working within Excel.
Attached is the sheet I am working on.
This is a simple function, so probably no problem for you Excel wizards out there .

Basically..

The D column contains data, such as H2, H3, J1, SO.
Cells M2 - M6 are the values that I wish to be displayed within the E column.

Basically, within the E column. If the cell in the D Column is, for example H2, E should display "Rig 2 Gang", if H3 then "Rig 3 Gang", if J1 then "Jobber", if SO nothing needs to be displayed as these are being deleted.

Any help would be greatly appreciated

Cheers,

Nick

[NBVC]

In L2:L6 add the corresponding column D possibilities, then you can use Vlookup

e.g.

=VLOOKUP(D2,$L$2:$M$6,2,0)

copied down

where L2:L6 contain, H1,H2, H3, H4, J1

[NBVC]

or you can just use:

=IF(D2="J1","Jobber","RIG "&RIGHT(D2)&" GANG")

copied down.

[NickPDC]

Absolutely brilliant!

Thank you very much!