Column Reference Based on Value

[Guest]

I have columns A - AA and want to be able to seach through columns A - AA to
find an instance of a Job Code- i.e. "WELDER" in any of the columns and
within other text within each column. Will only occur once per row. It is
case sensitive so "WELDER" # "Welder". I would like to place the column value
in column AB.

I know this is simple for most of you posting here, but I rarely use Excel
to this extent.

Thanks to everyone for your help.

Efrain

 

[Guest]

Perhaps:

=MATCH("*welder*",A1:AA1,FALSE)

This gives you the column number.
It can find welder inside of another string
It will find both upper and lower case welders

 

[Guest]

Worked like a charm. Thank you for your prompt posting.

Efrain