Hello!  I am having trouble with a xlookup formula and need gudiance in how to resolve.  

Here is the issue:    

In Column H I have the following formula H3 =MID(C3,21,3) which displays 131

Now on column N3, I have this formula:  XLOOKUP(H3, Final!B4:B140, Final!C4:C140) but i am getting a #NA instead of getting “cash.    Any thoughts?  see attached.

Please attached file tab 8852

​Hello!  I am having trouble with a xlookup formula and need gudiance in how to resolve.   Here is the issue:    In Column H I have the following formula H3 =MID(C3,21,3) which displays 131 Now on column N3, I have this formula:  XLOOKUP(H3, Final!B4:B140, Final!C4:C140) but i am getting a #NA instead of getting “cash.    Any thoughts?  see attached.Please attached file tab 8852  Read More

​