Hi Guys
I am trying to locate the next value higher as in if my INDEX cannot find an exact MATCH then return the next highest value.
something like here, but it doesn't work for me.
https://www.dropbox.com/s/yhsth5291a...4592.xlsx?dl=0
Hi Guys
I am trying to locate the next value higher as in if my INDEX cannot find an exact MATCH then return the next highest value.
something like here, but it doesn't work for me.
https://www.dropbox.com/s/yhsth5291a...4592.xlsx?dl=0
Last edited by martinl; 09-07-2016 at 06:55 AM.
OK solved but not as I thought
A bit outside of the box but attached is my solution
https://www.dropbox.com/s/yhsth5291a...4592.xlsx?dl=0
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks