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

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

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

=LOOKUP(A1,{0,25,30,35,40,47,50,52,58},{"F","E","D ","C","B","A-","A","A+","A*"})

adjust the mark thresholds and grades to suit

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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

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

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