Look ups

[RussChilds]

Hi,
I have the following data i want ti se up in a Lookup table.
38-40 = A*
33-37 = A
28-32 = B
23-27 = C
18-22 = D

How do I set this up and what formula would I use to convert Marks to Grades?

Many thanks!!
Russ

 

[VoG]

Try like this

Excel Workbook
	A	B	C	D
1	18	D	25	C
2	23	C
3	28	B
4	33	A
5	38	A*
Sheet2

 

[RussChilds]

Thank you - thats great

 

[nattasiray]

Re: VLOOKUP

Or you can use VLOOKUP.

= if(isblank(cellRef,0,Vlookup(CellRef,{18,"D";23,"C";28,"B";33,"A";38,"A*"},2))

My formula not required the reference table is stored the point and the grade level. Reduce file size.

CellRef is the cell that store the summary point.

HTH

 

[VoG]

Or

=LOOKUP(A1,{18,23,28,33,38},{"D","C","B","A","A*"})