| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup
I want to use VLOOKUP to locate a value in an array – but if there is nothing in the input cell - the formula cell returns a #N/A. What can I add to the VLOOKUP formula so the cell remains blank if there is nothing in the input cell? =LOOKUP(D17,O44:P654)
Thanks EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup
=if(iserror(LOOKUP(D17,O44:P654)),"",lookup(d17,o4 4:p654)) James wrote: I want to use VLOOKUP to locate a value in an array – but if there is nothing in the input cell - the formula cell returns a #N/A. What can I add to the VLOOKUP formula so the cell remains blank if there is nothing in the input cell? =LOOKUP(D17,O44:P654) Thanks EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get correct results when LOOKUP with calculated numbers | Excel Worksheet Functions | |||
| Another way to lookup data | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
