View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DORI
 
Posts: n/a
Default How to find a range of numbers?

I am creating a worksheet for my work. I have a chart (200 rows by 20
columns) of data (all numbers). I want to enter a number and would want the
Excel to look it up in the chart and tell me where the number is located in
relation to the title of the column and the row. Can any one help me what
formula I should use?
Thank you in advance.
DORI