Poupart interview questions

I applied online and had the face to face interview in Nov 2016 with 2 people in a room. Was presented with the excel file on a big screen with four tables: product reference, purchases, sales and expenses. The goal is to find the profit loss. Sounds easy, but the reference table is missing the details (weight and number of units per box) of one product that is listed within purchases and sales tables. However, they expect you to figure out that this info is coded within ID (primary key) of product (e.g., ID10X500) I noticed that and answered the question correctly which was acknowledged by the interviewer. The agent came back to me after 5 days with feedback that I haven't passed the excel test. Very strange. Agent pointed out that they've turned so many people down. The test is not measuring any BA competency and in my working experience I've never seen someone coding such info within ProductID.