checking for blank cells when using vlookup
 

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

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