| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LOOKUP FUNCTION HELP
Greetings everyone,
I just looking around and found on some other post a suggestion to find the last value of a series of data in a column (Col E in this case), which is: =+LOOKUP(9.99999999999999E+307,E:E) I'm trying to understand how this formula works; I read the help file's content for the Lookup function and it is still not clear to me how it works in this case. I'd appreciate if someone could explain this to me. Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
| if then /lookup function | Excel Worksheet Functions | |||
| LOOKUP function -help! | Excel Worksheet Functions | |||
| Help with lookup function | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Threaded Mode
