Solved: If Vlookup, Formula is case sensitive???

[Hoopsah]

Hi

I am using a formula in cell O2:

=IF(M2="","",VLOOKUP(M2,Rates!$B$17:$O$1500,13,FALSE))

For some reason though it appears to be case sensitive,

The coding in Rates is written as MET1, but if cell M2 has met1 then it comes back as N/A

Any ideas?

[Hoopsah]

Sorry,

On further checking it is not case sensitive at all - My Bad.

However, it does still come up with N/A unless I go into cell M2 and re-type the information.

Copying down the screen doesn't work, is there perhaps a checkbox somewhere in the options that i should have ticked?

Anybody came across this?

[Hoopsah]

OK,

If anyone is reading this I am really, really sorry.

I was panicking a bit as it was someone elses spreadsheet that I was trying to fix and I have since realised that in cell M2 there was a space after the met1

I have now amended this and once again sorry to bother anyone on here - if I could have access to a massive delete button I would use it.

Mark as solved anyway!

P.s. not just trying to get my post count up ;)