View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Efrain Efrain is offline
external usenet poster
 
Posts: 4
Default 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