You can return the last numeric value in a column when you use an extremely large number as the lookup value (to be sure that it will be larger than any number) and 9E+100 is an EXTREMELY LARGE number, it a 9 with 100 zero behind it. Almost a Googol number https://en.wikipedia.org/wiki/Googol
=VLOOKUP(9E+100... for numeric to return the last value
I would ad when searching for the last text value a series of "zzzzzzz" will have the same effect for text than 9E+100 for numerics
=VLOOKUP( "zzzzzzz".... for text to return the last value
Hello,
9E+100 is the scientific notation of 9 x 10^100 and that got nothing to do with a cell E9 but a very large number with a leading 9 followed by 100 zeroes ( just like 9 million = 9 000 000 [9 and 6 times a zero] in scientific notation would read 9E+6)
See also Number Format Codes in LibreOffice Help.
Hope that helps.
If the answer is correct or helped you to solve your problem, please click the check mark (✔) next to the answer.
Asked: 2019-11-29 00:05:15 +0100
Seen: 160 times
Last updated: Nov 29 '19
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
