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