Lookup

I am wanting to find the largest number in a column and I have in the past used LOOKUP(BigNum,[range]) This time I am using it on a column that has formulas in each of the cells to attain the number in them. When I use the usual formula I just get the error #NAME?
What am I doing wrong?

Can you post the actual formula, or better yet attach a copy of the book?

#Name error means you misspelled the function, or an argument.


FYI, the lookup(bignum,range) doesn't find the 'largest' number in a range (the MAX function does that). It actually finds 'the last' number in a range.

Do you have named ranges for BigNum and tix ?


Pictures are not very helpful at all (I can't copy/paste data into my own Excel Sheet to work on it.)
Can you attach an actual Excel file ?

how do I attach the file?

Click 'Go Advanced' (next to the Post Quick Reply button at bottom right.
Click on the 'Manage Attachments' link.

is that it attached?

BigNum is not a recognized function or name to Excel. (it's a friendly name that Excel users have given to the largest number allowed in a cell)

So this won't work
=LOOKUP(BigNum,tix)
Because Excel doesn't know what BigNum is.

You would have to do
=LOOKUP(9.99999999999999E+307,tix)

OR, create a Named Range (like tix) that equals 9.99999999999999E+307

Thank you very much - I will do that and see where it gets me. Thanks again for your help, appreciated

You're welcome