See for a set of alternative approaches:

http://www.mrexcel.com/board2/viewtopic.php?t=62102

BTW, also investigate whether you can sort the lookup table(s) you use
for that would allow you to do faster lookups (with added bonus no #N/A's).

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