Hi Guys

I have a spreadsheet where I get a mixture of either 0 results (because the field found is empty) or #N/A results (because a match isn't found) from a vlookup.

I need both of these to just return an empty cell.

Any ideas how? I've managed one or the other but getting in a muddle over doing both!

Thanks
Shell