Help needed adding the last bit to a formula

[bionicle]

hi All,

wondering if someone could help me out in figuring out the last part (I hope) to a formula.

I have the below formula which returns the correct information however I would like it to add a figure to the end of the text.

this formula =IF(W2="(Subcontractor)",K2& " (Subcontractor)") returns as Mr Higgins (subcontractor) whoever I need it to put a number at the end of the column (1-100) but I also need it to see additional (subcontractor) cells and therefore make to number add 1 each time.

if column "W" has 15 cells with (subcontractor) in them it needs to count on 1 each time.

hope that makes sense..

steve

 

[a_songaila]

Do you have an example spreadsheet?

 

[mooseman]

This is not an easy formula. Do you need the cells that don't match to be blank?
This will work, but the non-matching cells need to carry the count forward so the matching cells can calculate the correct number of subcontractors.

=IF(W4="(Subcontractor)",K4&" (Subcontractor) "&IFERROR(VALUE(RIGHT(A3,1))+1,1),VALUE(RIGHT(A3,1)))

I hope this helps and I understood you question correctly.

 

[bionicle]

Thanks for the info, all sorted now.

much appreciated