Column Reference Based on Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top