View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default Wild Card Search

How about:

=IF(A2=C$1,B2,"")

entered into C2 and copied down as necessary.

Hope this helps.

Pete