| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to reference a null value? ie: =Lookup("", B2:B4, A2:A4)
I'm trying to reference a null value in the lookup function and I keep
getting #NA back in return. Is there anyway I can do this? =Lookup("", B2:B4, A2:A4) gives me #NA. Basically in column B I want to lookup the first blank cell and want to return the contents in column A in the same row. How can I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperion Essbase Excel Add-in - returning text ("0") for null valu | Excel Discussion (Misc queries) | |||
| VBA returning "Null" for TextBox.Font.Size | Charts and Charting in Excel | |||
| How to write parameter query with "or is null" criteria | New Users to Excel | |||
| cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) | |||
| "IF"- "THEN" type Formula based on Null value | Excel Worksheet Functions | |||
Threaded Mode
