How do I get the next higher value returned using lookup or vlookup instead of the greatest value which is less than the ref value?
How do I get the next higher value returned using lookup or vlookup instead of the greatest value which is less than the ref value?
Hi ronconway...
I would suggest you to look into MATCH function where there is an option of looking greater / less than values.
If you combine Index with Match or even Offset with Match, you can get your desired output. Post an sample file if you face any challenges there.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks