Column Reference Based on Value
 

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

Column Reference Based on Value
 

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
--
Gary's Student
gsnu200705


"Efrain" wrote:

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

Column Reference Based on Value
 

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

Efrain

"Gary''s Student" wrote:

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
--
Gary's Student
gsnu200705


"Efrain" wrote:

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