Thread: Find Column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Airfive Airfive is offline
external usenet poster
 
Posts: 12
Default Find Column

Hello all,

Try as I might, I just can't seem to get my quandry solved and I need some
help. I have a worksheet with data located in the range of A9:M49. I am
trying to search through this range of data looking for a particular value.
When the value is found, I want to return the column header that the value is
in. I have been trying to use the index/match functions but I can't get
quite what I need. Could someone possibly give me some pointers. Thanks.

Ron