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.
|