View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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