=IF(isblank(a1),"",Vlookup(a1,....))


"Richard" wrote:

> Hi,
>
> I'm using vlookup to return a value, if there is one, from another
> worksheet. The problem I'm encountering is that vlookup will return a zero if
> there is no value to return. How do I get to return an empty cell if it
> cannot find a value to return?
>
>
> Thank You,