Hi Guys, can anyone help?
I'm using VLOOKUP in Excel 2000 to obtain a value from an array. VLOOKUP returns a value that is <= the lookup_value. I need the next highest value. e.g. in the array "Area"
lookup_value = 1000
VLOOKUP(1000,Area,2,True)
"Area" Array values...