I believe this has something to do with formatting. If I copy 221051 from cell A165 and paste it into cell C1 where users will enter the account, I then get the correct outcome and it returns 'N'. If it is a formatting issue, my problem is I can set the format a certain way, but users may manually enter in C1 or they might copy/paste the number from another Excel document. I can't necessarily control the formatting because of this.

Because of this, and if the Lookup functions require like formatting, I'm just wondering if there is another formula that could be used to find the Account number and then pull in the value of Column N in that same row.