In spreadsheet the search criteria in a VLOOKUP functions is 9E+100. The column expected to search is E and I would understand E9, but what does 9E+100 mean?

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.*

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 Googol - Wikipedia

=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