| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
need Lookup table to return null or zero
I need the lookup fucntion to return a null or a zero when it cannot
find the value required? Currently it is returning the next nearest value!! For example: Col A Col B 07-Jul-05 1 08-Jul-05 4 11-Jul-05 3 12-Jul-05 3 If I lookup for 9-Jul-05 It will return "4" where I need a 0 or null!! Must be an easy one but I have gone cross eyed!! Chairs |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a lookup table with an added varable? | Excel Worksheet Functions | |||
| Return cell contents based on conditional lookup | Excel Worksheet Functions | |||
| Lookup with multiple value return | Excel Worksheet Functions | |||
| Return Multiple Results with Lookup | Excel Worksheet Functions | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
Threaded Mode
