=LOOKUP(9.99999999999999E+307, A:A)
This formula finds the value at the bottom of its range.
I want to use this formula to search a different sheet but I can't work out where I should add 'sheet' 2 to it.
Can someone help with this?
Thanks
=LOOKUP(9.99999999999999E+307, A:A)
This formula finds the value at the bottom of its range.
I want to use this formula to search a different sheet but I can't work out where I should add 'sheet' 2 to it.
Can someone help with this?
Thanks
If you are searching in Sheet2
If your sheet name has spaces in it (i.e. Sheet 2), you need to use single quotes like soFormula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Many thanks
Please try
=LOOKUP(9^9,sheet2!A:A)
or
=LOOKUP(99^99,'sheet2'!A:A)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks