Forum Discussion
Can't seem to find the answer to a simple solution?
HansVogelaar Wow, fantastic!! Thank you!! I have no idea why that works reading the code but it does. Awesome!!
=LOOKUP(9.99999999999999E+307,E2:E9)
Why "+307" in this code?? I am trying to get it to work in a totally different spreadsheet but having trouble getting it to come out right. Is the ...+307... germane only to the example I provided above or is it a universal value that can be used in any column application?
Thanks
- Or does the "E" after all the 9's have to match the particular column that I want to use the formula in? Whether in the same spreadsheet or a completely different one?
The E indicates so-called exponential notation.
9.99999999999999E+307 is Excel's notation for 9.99999999999999*10^307.
It is the largest number that you can enter into an Excel cell, i.e. larger than any number you want the formula to return. LOOKUP searches for this number, and since it cannot find it, it returns the last number it found.
I did a copy/paste of the code into cell G26 of another spreadsheet, but no value is showing up. Is there a reason why? The value in G26, in this example, should read 2,295 (G5).
Could it have something to do with the values that appear in this column already have a code for each of their individual cells? =SUM(E2*0.8)... E3, E4, etc. up to E25.
