Errors in Vlookup from another sheet

I have a sheet with a VLOOKUP formula =VLOOKUP(G2,'Exam Marks'!A:B,2) with 20 entries - it is working well but there are 3 errors out of the 20 (in red) as I have provided in the sample.

The correct values are in green to the right of the data.

Any ideas please?

TIA Doug

As your lookup table is not sorted you need to specify the last argument in the Vlookup as false, or 0
=VLOOKUP(G2,'Exam Marks'!A:B,2,0)

Thanks Fluff and Harribone. I'm new to Vlookup so I was surprised I was that close!

That has helped me out. Also I did a Trim and paste values which I think may have caused some errors in my original sheet.

Reps added.

Thanks again.

You're welcome & thanks for the feedback.

Hi I have another quick question. I can't get conditional formatting to work on this sheet.

I am trying to colour all values 29 and above green.

All values under 29 yellow.

All the values stay green.

I haveused Conditional Formatting a lot and haven't seen this error.

It doesnt happen in the other score columns H I J

Thanks again

That's because most of the "numbers" on the Exam sheet are text & not real numbers.

Ok I solved it by using =value to make it a number and copy paste special values. So all good!

Thanks again Fluff - you beat me to it.