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