explanation of formula please

Originally Posted by twiggywales

so if you had

A, D, F, M, B

why whould it show B not M as M is the largest value

or is it always the last cell

I meant to say that LOOKUP expects the data to be sorted, so in your example it will return B as that is the last cell which is less than "zzzz...", so yes, it will always return the last value in the list.

Hope this helps.

Pete