Here is a link to my sheet.
I am trying to do some base 36 to binary encoding and VLOOKUP claims to not be able to find the values of column E even though they are clearly there.
I've narrowed down the problem, if I put in a specific value (say '7') into VLOOKUP, it can find it just fine. It is when I ask it to find a value which itself is the result of some equation that VLOOKUP fails. I need to be able to change Encoded Value and get the apporpriate decimal number.
Also, if I change the Encoded Value to, say, AAAA, then VLOOKUP does just fine and gives values of 10 for all of them. It seems to only be an issue when it is looking for numerics from Encoded Value.