Hi tutors. I am a little stuck on these 2 questions (C4 and C5).

Any ideas on what the VLOOKUP formulas should look like?

B C D E G M P Q S Inventory PART CODE IMAGE DESCRIPTION SUPPLIER SUPPLIER CODE COST EACH MIN STOCK IN STOCK BACKORDER CATEGORY RE-ORDER? RE-ORDER QTY Supplier Min Order Qty Parts Average Value Items on Backorder PX723541 DESCRIPTION White & Portico W529196/78 $1.66 200 239 H&W 25 $3.57 3 4 12 PX723542 DESCRIPTION Buggins 8557761/77 $1.99 200 198 A ABC White & Portico 30 $8.58 5 15 PX374561 IMAGE $2.74 A UNAVAILABLE DESCRIPTION White & Portico W664956/39 200 63 Buggins 55 $4.14 6 11 PX820261 DESCRIPTION White & Portico W771072/53 $12.99 100 292 B PX820262 DESCRIPTION Buggins B567350/21 $13.19 100 163 Reorder % over 25% Minimum PX1004683 DESCRIPTION White & Portico W701735/28 $13.19 100 256 B PX820266 DESCRIPTION Buggins B326854/81 $10.99 100 66 10 PX723593 DESCRIPTION H&W H448251/40 $1.91 200 268 A 11 PX374089 DESCRIPTION White & Portico W426061/24 $53.11 50 105 B y 12 PX723557 DESCRIPTION Buggins 3472237/18 $2.49 200 249 A y 13 PX723820 DESCRIPTION Buggins B420251/20 $2.49 200 138 A 14 PX807530 DESCRIPTION White & Portico W564399/34 $2.99 200 181 A 15 PX820728 DESCRIPTION White & Portico W591861/33 $2.19 200 272 A y 16 PX723594 DESCRIPTION H&W 1326781/31 $2.39 200 86 A 17 PX723206 DESCRIPTION Buggins B433191/70 $1.99 200 177 A 18 PX373195 DESCRIPTION White & Portico W592160/27 $2.49 200 231 A y 19 PX723745 DESCRIPTION Buggins B675073/41 $3.11 100 36 A 20\fThe Bill of Materials itemises the quantities of each component required to make the two products. In column D use a formula to get the appropriate Part Description for each Part Code from the Inventory table. C5 In column E use a formula to get the appropriate Unit Price for each Part Code from the Inventory table