checking for blank cells when using vlookup
Maybe...
=if(a1="","",vlookup(a1,sheet2!a:e,5,false))
Koomba wrote:
I am jusing the following formula in my sales order form and want to avoid
the error message: #N/A caused by blank cells in the remainder of the sales
order. I thought of trying to combine an IF or ISBLANK function with the
VLOOKUP. Any help here?
--
Thanks from Salt Spring
--
Dave Peterson
|