View Single Post
  #4   Report Post  
Shirley
 
Posts: n/a
Default

If more than one month has the same value, I would want it to list the latest
month.
I think I misunderstood the VLOOKUP function. I thought it returned a cell
reference, not a value in the cell??
--
Shirley


"Dave O" wrote:

This could be done using a VLOOKUP. But how do you handle 2 months
having exactly the same number? If MAR and APR were both 200, what do
you do? The answer will determine how to resolve the overall question.