VLOOKUP not working on table created with sharepoint query

I have a table its in a worksheet called RMs.   The table is made from a query of a sharepoint list, which is a raw materials database held on SP.   On another sheet a user can enter a raw materi...