ps.

You can use:
=IF(VLOOKUP(CONCATENATE($A61,"schg"), ...
or
=IF(VLOOKUP($A61&"schg"), ...

But you don't need to concatenate a string that's already concatenated.


Loni - RWT wrote:

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))

--

Dave Peterson