PDA

View Full Version : Solved: If Vlookup, Formula is case sensitive???



Hoopsah
11-16-2012, 04:59 AM
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
11-16-2012, 05:32 AM
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
11-16-2012, 05:43 AM
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 ;)