Hi,

I have 2 questions (C4 and C5) asking me to work with excel functions which I am stuck on. Any help is appreciated!

The 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. \fQ12 X V fx B D G H 1 Inventory PART CODE IMAGE DESCRIPTION SUPPLIER SUPPLIER CODE COST EACH MIN STOCK IN STOCK BACKORDER CATEGORY RE-ORDER? RE-ORDER QTY PX723541 DESCRIPTION White & Portico W529196/78 $1.66 200 239 PX723542 DESCRIPTION Bugging 8557761/77 $1.99 200 198 PX374561 UNAVAILABLE DESCRIPTION White & Portico W664956/39 $2.74 200 53 PX820261 DESCRIPTION White & Portico W771072/53 $12.99 100 292 PX820262 DESCRIPTION Buggins 8567350/21 $13.19 100 163 PX1004683 9 DESCRIPTION White & Portico W701735/28 $13.19 100 256 PX820266 DESCRIPTION 10 Buggins 8326854/81 $10.99 100 66 PX723593 DESCRIPTION H&W 11 H448251/40 $1.9 200 268 PX374089 12 DESCRIPTION White & Portico V426061/24 $53.11 50 105 PX723557 13 DESCRIPTION Buggins 3472237/18 $2.49 200 249 PX723820 DESCRIPTION 14 Buggins B420251/20 $2.49 200 138 PX807530 15 DESCRIPTION White & Portico W564399/34 $2.99 200 181 PX820728 DESCRIPTION 16 White & Portico V591861/33 $2.19 200 272 PX723594 17 DESCRIPTION H&W H326781/31 $2.39 200 36 PX723206 18 DESCRIPTION Buggins B433191/70 $1.99 200 177 PX373195 DESCRIPTION 19 White & Portico V592160/27 $2.49 200 231 PX723745 DESCRIPTION 20 Buggins 3675073/41 $3.11 100 36 PX577199 DESCRIPTION White & Portico W361589/24 $1.99 200 39 PX725125 DESCRIPTION H& W 22 H467610/39 $2.19 200 90 PX796490 DESCRIPTION 23 Buggins $712863/57 $2.49 200 180 PX807531 DESCRIPTION 24 White & Portico W439743/32 $1.66 200 145 PX807532 DESCRIPTION 25 White & Portico W629507/25 $1.74 200 183 X723566 ESCRIPTION H& W H683213/67 $2.20 200 202PX807532 DESCRIPTION White & Portico W629507/25 $1.74 200 183 25 PX723566 DESCRIPTION H&W H683213/67 $2.29 200 202 26 PX820263 DESCRIPTION Buggins B347655/87 $2.49 200 234 27 PX792653 DESCRIPTION White & Portico W724130/13 $2.08 200 52 28 PX823385 DESCRIPTION H&W H578246/26 $1.66 200 273 29 PX860085 DESCRIPTION H&W H396220/43 $2.19 200 207 30 PX823386 DESCRIPTION H&W H3 19247/65 $1.74 200 13 31 PX820834 DESCRIPTION Buggins B668438/72 $1.99 200 300 32 PX723596 DESCRIPTION H&W H558841/85 $2.49 200 171 33 PX723742 DESCRIPTION White & Portico W678322/30 $1.74 200 68 34 PX723743 DESCRIPTION Buggins B517373/85 $2.29 200 92 Y 35 PX797516 DESCRIPTION H&W H539656/85 $1.83 200 195 Y 36 PX242979 DESCRIPTION White & Portico W487032/43 $1.83 200 280 37 PX823978 DESCRIPTION White & Portico W325980/58 $26.24 50 74 38 PX807540 DESCRIPTION H&W H531341/87 $3.33 100 209 39 PX807539 DESCRIPTION H&W H410102/85 $18.69 50 107 PX809486 O DESCRIPTION H&W H456602/63 $2.08 200 106 41 42 43