You could do something like this...

=IF(A1="A*",58,<<your LOOKUP formula goes here)

Rick


"Greener2224" wrote in message
...
I want to convert grades to marks A* is 58 points A is 52 etc. I have been
using lookup tables but they return A* as 52 points because of the
wildcard
character any suggestions.
Thanks