way too much to type 50 times a day, especially in sheets that are already at
or past the limit of my 1GB of ram.

"ward376" wrote:

You could use isna in your formulas to keep the na values from
appearing:

=IF(ISNA(VLOOKUP(B1,$D$1:$E$7,2,FALSE)),"",(VLOOKU P(B1,$D$1:$E
$7,2,FALSE)))

Cliff Edwards