To prevent the #N/A allow it to happen, hide the column, and reference it
with: =IF(ISNA(A1),"",A1)

#REF! means you have a dud reference.
http://www.ozgrid.com/Excel/formula-errors.htm
http://www.ozgrid.com/Excel/debug-formula-errors.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Samantha" wrote in message
...
I am trying to lookup a value in one worksheet, find an approximate match
in
another table, and return the corresponding value from the 2nd column of
the
lookup table. I get either #NA or #REF!
Please help!?!?!