Originally Posted by Hessah
|
|
I think the LOOKUP formula requires you to sort the column in alphabetical order isnt it?
|
I think you don't have to if you put a 0 at the end (tells it to be an exact match).
|
Quote:
|
|
And that's for looking up a specific text?? We want it to show the last cell of a column...
|
You can change the last column to be whatever you want it to be. I just put in text for an example.