Showing results for 
Search instead for 
Did you mean: 

Lookup Limited to Rows without a Null Value

7 - Data Storage
7 - Data Storage

Is there a method or formula to use a lookup, but only obtain the first instance that has a real value, and not a null (n/a) value?  In addition, is there an explanation manual available of formulas which a person with no IT skills can use to understand how to fix formulas?

Voice of Customer
Impact Business Intelligence (BI) and Analytics Market Research

Click Here & Complete Dresner's Wisdom of Crowds® Market Study Survey Today!

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request

Don't miss out:

Earn a BETA Launch Challenge Badge!