-
Solved: If Vlookup, Formula is case sensitive???
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?
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe
-
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?
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe
-
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
I am playing all the right notes, but not necessarily in the right order.
Eric Morecambe
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules