This formula works fine for me in Excel 2007. It returns a value from the
table if the lookup value exists, if not it returns #N/A

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

I seem to remember that "transistion formula evaluation" has something to do
with Lotus 123. Are you working with or converting 123 workbooks?

Tyro

"Loni - RWT" wrote in message
...
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.