It is a big number 9.99*10^307
Used in this context it ensures LOOKUP returns the value from the result_vector associated with the last numeric value found in the lookup_vector
Brief overview: http://www.excelforum.com/2466052-post12.html - though this is aimed at the text equivalent the same principles hold true for this numeric version
Bookmarks