Vlookup Does Not Recognize Item In An Array

I am working with a friend on their spreadhseet which uses several vlookups in order to pull information cells in one worksheet to another, and also to pull object types from a list with values saved as an array. However, one item in the array consistently does not appear.

I noticed that his array has 4 columns, unsorted, where I would have used 2 (one with the object type, and the second with the value corresponding to that object type) and then sorted them.

The error he gets is "A value is not available to the formula or function", even though the value is in the array.

I have already eliminated formatting, spelling errors, bad formula (it works for the other types), and all I can come back to is the array.

The file is too large to attach, so I am attaching some description of the formulas and the structure of the array.