Forum Discussion
Match
How can I have the last item in the lookup_array to be returened, or how can I check the lookup_array from the bottom to up, say A10:A1, so that the value is the first item from the bottom of the array ?
- Use lookup function.
=lookup(999999999999999,array)
