If a column has X value and is in Y column, then....

Hi everyone,

Long time leecher, first time poster.

I'm trying to go through a range of columns and do something depending on which column the cell is in.

Basically,

Please Login or Register  to view this content.

I just can't work out the syntax to check which column the cell is in.

Any help you can provide is appreciated.

Something like this maybe

Please Login or Register  to view this content.

Perfect. Thanks Millz.