Thanks for your reply. That is what I started with but got #Value! when
there was no match for the lookup value which is why I was trying to
incorporate the IF statement. In another post concerning a cell calculation,
I unchecked the "transition formula evaluation" option and when I did, the
VLookup function returned #N/A on no match.

"Tyro" wrote:

This will return #N/A all by itself if the lookup value is not found.

=VLOOKUP(CONCATENATE($A61 & " schg"),CurrentTaxRates,2,FALSE)

"Loni - RWT" wrote in message
...
I've got a workbook w/ one sheet that has downloaded fuel tax rates named
CurrentTaxRates. On another sheet in the workbook, I'm trying to obtain
the
tax rates via lookup functions for particular states. Some states, but
not
all, have a surcharge rate in addition to the tax rate. I have the
following
formula which is giving me the surcharge rate for the states that have
one.
However, if a state does not have a surcharge rate, it's giving me an
error -
#VALUE! How do write it so that if a state does not have a surcharge
rate,
it returns "N/A" ? Thanks for your help

=IF(VLOOKUP(CONCATENATE($A61 & "
schg"),CurrentTaxRates,2,FALSE),NA,VLOOKUP(CONCATE NATE($A61 & "
schg"),CurrentTaxRates,2,FALSE))