| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Lookup function
Hello,
I want to have excel lookup something in a lookup table when the date mentioned is past the present date. This is what I have : =IF(N8NOW();VLOOKUP(A8;uurschema;3;FALSE);0) Where N8 = column with the date. However this doesn't work. It just says 0. How do I get this to work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i use > in lookup function? | Excel Discussion (Misc queries) | |||
| Lookup Function Error | Excel Worksheet Functions | |||
| Lookup Function Problem | Excel Discussion (Misc queries) | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| LOOKUP FUNCTION WITH SUMS ABILITY | Excel Discussion (Misc queries) | |||
Threaded Mode
