# VLOOKUP and A*

1. ## VLOOKUP and A*

Morning,

I am using a vlookup to change school grades into point scores, using the formula:

=IFERROR(VLOOKUP('Y13'!R2,LOOKUP!\$D\$2:\$E\$8,2),"")

'Y13'!R2 is where the grade is
LOOKUP!\$D\$2:\$E\$8 is where the grade to point table is

This works fine for all the grades with the exception of A* (which is in D2 of the table) as it just returns the points for an A grade.

Is there anyway to change this?

Thanks  Register To Reply

2. ## Re: VLOOKUP and A*

Use

In your lookup range (D2:E8) ensure that A* is above A. Then use

=IFERROR(VLOOKUP('Y13'!R2,LOOKUP!\$D\$2:\$E\$8,2,FALSE),"")

for an exact match  Register To Reply

3. ## Re: VLOOKUP and A*

Try one more approach..

Formula:  `Please Login or Register  to view this content.`  Register To Reply

4. ## Re: VLOOKUP and A*

why not just lookup instead of two functions vlookup then lookup?

something like

=LOOKUP(A1,{0,75,80,85,90,95},{"F","E","D","C","A","A+"})  Register To Reply

5. ## Re: VLOOKUP and A*

Many Thanks  Register To Reply