Having some trouble developing a small part of a large formula.
I want to see if a figure in A1 exists in range B1:B10
If it does exist i want to return that number
If it doesn't exist then i want to return the next highest number...
Struggling.
p.s. i can't use an array forumla
Any help would be appreciated!
Bookmarks