Hi,

Hi,

Your welcome and thanks for the feedback. Your formula would have worked had
you sorted column A.

Mike


"Greener2224" wrote:

Thanks Mike this exactly what I wanted I had VLOOKUP(E1,A1:B3,2,1) and just
changing the 1 to false works well


"Mike H" wrote:

Hi,

This works for me. Build a table like this which in my case is in columns A
& B

A* 58
A 52
B 44

Then use the formula
=VLOOKUP(E1,A1:B3,2,FALSE)
With the lookup value in E1


Mike


"Greener2224" wrote:

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