Button for populating cell with '1' IF row contains certain characteristics

[harrylucas]

Hoping you can help

Please see attached spreadsheet

D007.xlsm

I would like a button that says 'Populate 1' above the cell that says 'Item', and any blank cell between the F and J column will populate with '1' IF the row contains either PI, VI, FT or TR (would be in the C column)

It needs to be for the entire column and not a specific set of cells as the length of this spreadsheet can vary.

How can I go about doing this?
TIA

[sweep]

Hi,

You could approach it like this..

Please Login or Register  to view this content.

[Mumps1]

Another approach:

Please Login or Register  to view this content.

[harrylucas]

Thank you both, they both work perfectly.

There has been an oversight on my part, though - I only want those cells to populate if the the yellow cells (F14-J14) also contain any value.

Thanks again

[Mumps1]

Try:

Please Login or Register  to view this content.