Works great. Thanks very much for the suggestion.

"BCGROUPNY" wrote in message
...
Try using the isna() function, @if(Isna(vlookup.....),"",(vlookup.....))

"mick.smith1964" wrote:

Hi

I have alot of Vlookup functions in a worksheet. Some return values,
others
do not which results in #N/A in the cell.

Is there a way to avoid #N/A being returned. All I want is either a
positive
value or an empty cell.

Thanks for any suggestions