Hello,

I have a Workbook that i have built as a D&D character sheet. Everything is working fine, except for one formula, which is throwing out a very peculiar bug:

=IF('Character Sheet'!$D$4>=K27,VLOOKUP(K27,INDIRECT(Sheet2!$J$12),8,FALSE),"")
Character Sheet D4 holds the character level, K27 is a comparison to see if they are at the right level for the feat

If they are, it looks up the level in a named range of levels with various stat modifications, inlcuding feats. For level 20, it returns a blank, when it should return:

Put your Hands up – First turn of combat, can roll a Charisma Check. Score of 20(not natural) or more means all enemies surrender. Unique enemies require a natural 20
However it returns a blank. after some investigation, it is the presence of the '20's that's causing problems. if i replace with another number (E.g. 19), or 'Twenty' the formula returns the string fine.

Does anyone know why?