View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jenn jenn is offline
external usenet poster
 
Posts: 107
Default cell refrence based on specific criteria

I am trying to refrence a specific cell based on set criteria.
I have a cell with a current calcualtion. I am then wanting to find out
what cell is associated with that number, for example I have ratios running
along side a ratio count column (1, 2, 3, 4 and so on).
In my new cell I'm trying to say if the count ='s the value in my current
calculated cell, then this cells value is the ratio associated with that
count column.