My problem is that I wish to do a lookup/vlookup on a table , where the first column is in reverse order.
Column A has dates sorted in reverse order, the most recent at the top, and frequently the same date is repeated many times.
Using lookup or vlookup, I find that when the same date is repeated the one farthest down column A is used to provide the result, when in fact I need the higher one to be used for the result. I accept that some other worksheet function/s might do the trick, and would prefer not to use a macro.
Can someone please assist?
TIA.
Des.
Column A has dates sorted in reverse order, the most recent at the top, and frequently the same date is repeated many times.
Using lookup or vlookup, I find that when the same date is repeated the one farthest down column A is used to provide the result, when in fact I need the higher one to be used for the result. I accept that some other worksheet function/s might do the trick, and would prefer not to use a macro.
Can someone please assist?
TIA.
Des.