=if(isna(vlookup formula),"",vlookup formula)


"ExcelBee" wrote:

I am doing a VLOOKUP from a large table against smaller table that is missing
some of the data to look-up against. I had a formula I used years ago that
used ERROR, but of course, cannot remember how it went. Help!