A manager needs to identify some information from the purchase orders database but has only has the order number. Modify the excel file to use the VLOOKUP functions to find the item description and cost per order for the following order numbers Aug11008, Sep11023, and Oct11020.

Pleaseeeee provide the functions, having just the answers didnt help much Aug11008, Sep11023, and Oct11020.

AutoSave Off H2 Odeh, O HW3 Search Omar Odeh oo File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments # Insert Arial 12 AA == ab Wrap Text General s LIV Paste BIU A E E Merge & Center 2X Delete Format $ % -29 y Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity M4 N O Q R S A B E F H 1 J K L M M 1 Purchase Orders 2 3 Supplier Order No. Item No Item Description Item Cos Quantity Cost per orde A/P Terms (Month Order Dat Arrival Date item description 08 cost per order 08 item description 09 4 Hulkey Fasteners Aug 11001 1122 Airframe fastener $4.25 19,500 $82,875.00 30 08/05/11 08/13/11 Pressure Gauge #N/A 5 Alum Sheeting Aug11002 1243 Airframe fastener $4.25 10,000 $42,500.00 30 08/08/11 08/14/11 O-Ring 6 Fast-Tie Aerospace Aug11003 5462 Shielded Cable/ft $1.05 23,000 $24,150.00 30 08/10/11 08/15/11 Shielded Cable/ft. 7 Fast-Tie Aerospace Aug 11004 5462 Shielded Cable/ft $1.05 21,500 $22,575.00 30 08/15/11 08/22/11 Shielded Cable/ft. 8 Steelpin Inc. Aug 11005 5319 Shielded Cable/ft $1.10 17,500 $19,250.00 30 08/20/11 08/31/11 Electrical Connector 9 Fast-Tie Aerospace Aug11006 5462 Shielded Cable/ft $1.05 22,500 $23,625.00 30 08/20/11 08/26/11 Hatch Decal 10 Steelpin Inc. Aug 11007 4312 Bolt-nut package $3.75 4,250 $15.937.50 30 08/25/11 09/01/11 Electrical Connector 11 Durrable Products Aug11008 7258 Pressure Gauge $90.00 100 $9,000.00 45 08/25/11 08/28/11 Bolt-nut package 12 Fast-Tie Aerospace Aug11009 6321 O-Ring $2.45 1,300 $3,185.00 30 08/25/11 09/04/11 Control Panel 13 Fast-Tie Aerospace Aug 11010 5462 Shielded Cable/ft $1.05 22,500 $23,625.00 30 08/25/11 09/02/11 Electrical Connector 14 Steelpin Inc. Aug 11011 5319 Shielded Cable/ft $1.10 18,100 $19,910.00 30 08/25/11 09/05/11 Electrical Connector 15 Hulkey Fasteners Aug 11012 3166 Electrical Connec $1.25 5,600 $7,000.00 30 08/25/11 08/29/11 Bolt-nut package 16 Hulkey Fasteners Aug11013 9966 Hatch Decal $0.75 500 $375.00 30 08/25/11 08/31/11 Airframe fasteners 17 Steelpin Inc. Aug11014 5234 Electrical Connec $1.65 4,500 $7,425.00 30 08/28/11 09/05/11 Bolt-nut package 18 Steelpin Inc. Sep11001 4312 Bolt-nut package $3.75 4,200 $15,750.00 30 09/01/11 09/10/11 Airframe fasteners 19 Alum Sheeting Sep11002 5417 Control Panel $255.00 406 $103,530.00 30 09/01/11 09/10/11 Pressure Gauge 20 Hulkey Fasteners Sep11003 3166 Electrical Connec $1.25 5,500 $6,875.00 30 09/01/11 09/06/11 Electrical Connector 21 Steelpin Inc. Sep 11004 5234 Electrical Connec $1.65 4,850 $8,002.50 30 09/02/11 09/11/11 Airframe fasteners 22 Steelpin Inc. Sep11005 4312 Bolt-nut package $3.75 4,150 $15,562.50 30 09/03/11 09/11/11 Shielded Cable/ft. 23 Hulkey Fasteners Sep11006 1122 Airframe fastener $4.25 15,500 $65,875.00 30 09/04/11 09/12/11 Electrical Connector 24 Spacetime Technolo: Sep 11007 4111 Bolt-nut package $3.55 4,800 $17,040.00 25 09/05/11 09/20/11 Airframe fasteners 25 Alum Sheeting Sep11008 1243 Airframe fastener $4.25 9,000 $38,250.00 30 09/05/11 09/12/11 Bolt-nut package 26 Durrable Products Sep11009 7258 Pressure Gauge $90.00 120 $10,800.00 45 09/05/11 09/09/11 Electrical Connector 27 Steelpin Inc. Sep 11010 5234 Electrical Connec $1.65 4,750 $7,837.50 30 09/05/11 09/13/11 O-Ring 28 Hulkey Fasteners Sep 11011 1122 Airframe fastener $4.25 12,500 $53,125.00 30 09/05/11 09/11/11 Shielded Cable/ft. 29 Hulkey Fasteners Sep 11012 5066 Shielded Cable/ft $0.95 25,000 $23,750.00 30 09/05/11 09/12/11 Bolt-nut package 30 Hulkey Fasteners Sep11013 3166 Electrical Connec $1.25 5,650 $7,062.50 30 09/05/11 09/10/11 Shielded Cable/ft. . Airfra. fantana AOC 16.000 Coolest Purchase Orderpg 79#24 Sales#26p980 + Ready Circular References Luas TantARAPA 700.00 0010141 004C44 B + 73% Type here to search * a w ? 12 H 11:33 PM 9/12/2020 AutoSave Off H2 Odeh, O HW3 Search Omar Odeh oo File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments # Insert Arial 12 AA == ab Wrap Text General s LIV Paste BIU A E E Merge & Center 2X Delete Format $ % -29 y Ideas Sensitivity Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity M4 N O Q R S A B E F H 1 J K L M M 1 Purchase Orders 2 3 Supplier Order No. Item No Item Description Item Cos Quantity Cost per orde A/P Terms (Month Order Dat Arrival Date item description 08 cost per order 08 item description 09 4 Hulkey Fasteners Aug 11001 1122 Airframe fastener $4.25 19,500 $82,875.00 30 08/05/11 08/13/11 Pressure Gauge #N/A 5 Alum Sheeting Aug11002 1243 Airframe fastener $4.25 10,000 $42,500.00 30 08/08/11 08/14/11 O-Ring 6 Fast-Tie Aerospace Aug11003 5462 Shielded Cable/ft $1.05 23,000 $24,150.00 30 08/10/11 08/15/11 Shielded Cable/ft. 7 Fast-Tie Aerospace Aug 11004 5462 Shielded Cable/ft $1.05 21,500 $22,575.00 30 08/15/11 08/22/11 Shielded Cable/ft. 8 Steelpin Inc. Aug 11005 5319 Shielded Cable/ft $1.10 17,500 $19,250.00 30 08/20/11 08/31/11 Electrical Connector 9 Fast-Tie Aerospace Aug11006 5462 Shielded Cable/ft $1.05 22,500 $23,625.00 30 08/20/11 08/26/11 Hatch Decal 10 Steelpin Inc. Aug 11007 4312 Bolt-nut package $3.75 4,250 $15.937.50 30 08/25/11 09/01/11 Electrical Connector 11 Durrable Products Aug11008 7258 Pressure Gauge $90.00 100 $9,000.00 45 08/25/11 08/28/11 Bolt-nut package 12 Fast-Tie Aerospace Aug11009 6321 O-Ring $2.45 1,300 $3,185.00 30 08/25/11 09/04/11 Control Panel 13 Fast-Tie Aerospace Aug 11010 5462 Shielded Cable/ft $1.05 22,500 $23,625.00 30 08/25/11 09/02/11 Electrical Connector 14 Steelpin Inc. Aug 11011 5319 Shielded Cable/ft $1.10 18,100 $19,910.00 30 08/25/11 09/05/11 Electrical Connector 15 Hulkey Fasteners Aug 11012 3166 Electrical Connec $1.25 5,600 $7,000.00 30 08/25/11 08/29/11 Bolt-nut package 16 Hulkey Fasteners Aug11013 9966 Hatch Decal $0.75 500 $375.00 30 08/25/11 08/31/11 Airframe fasteners 17 Steelpin Inc. Aug11014 5234 Electrical Connec $1.65 4,500 $7,425.00 30 08/28/11 09/05/11 Bolt-nut package 18 Steelpin Inc. Sep11001 4312 Bolt-nut package $3.75 4,200 $15,750.00 30 09/01/11 09/10/11 Airframe fasteners 19 Alum Sheeting Sep11002 5417 Control Panel $255.00 406 $103,530.00 30 09/01/11 09/10/11 Pressure Gauge 20 Hulkey Fasteners Sep11003 3166 Electrical Connec $1.25 5,500 $6,875.00 30 09/01/11 09/06/11 Electrical Connector 21 Steelpin Inc. Sep 11004 5234 Electrical Connec $1.65 4,850 $8,002.50 30 09/02/11 09/11/11 Airframe fasteners 22 Steelpin Inc. Sep11005 4312 Bolt-nut package $3.75 4,150 $15,562.50 30 09/03/11 09/11/11 Shielded Cable/ft. 23 Hulkey Fasteners Sep11006 1122 Airframe fastener $4.25 15,500 $65,875.00 30 09/04/11 09/12/11 Electrical Connector 24 Spacetime Technolo: Sep 11007 4111 Bolt-nut package $3.55 4,800 $17,040.00 25 09/05/11 09/20/11 Airframe fasteners 25 Alum Sheeting Sep11008 1243 Airframe fastener $4.25 9,000 $38,250.00 30 09/05/11 09/12/11 Bolt-nut package 26 Durrable Products Sep11009 7258 Pressure Gauge $90.00 120 $10,800.00 45 09/05/11 09/09/11 Electrical Connector 27 Steelpin Inc. Sep 11010 5234 Electrical Connec $1.65 4,750 $7,837.50 30 09/05/11 09/13/11 O-Ring 28 Hulkey Fasteners Sep 11011 1122 Airframe fastener $4.25 12,500 $53,125.00 30 09/05/11 09/11/11 Shielded Cable/ft. 29 Hulkey Fasteners Sep 11012 5066 Shielded Cable/ft $0.95 25,000 $23,750.00 30 09/05/11 09/12/11 Bolt-nut package 30 Hulkey Fasteners Sep11013 3166 Electrical Connec $1.25 5,650 $7,062.50 30 09/05/11 09/10/11 Shielded Cable/ft. . Airfra. fantana AOC 16.000 Coolest Purchase Orderpg 79#24 Sales#26p980 + Ready Circular References Luas TantARAPA 700.00 0010141 004C44 B + 73% Type here to search * a w ? 12 H 11:33 PM 9/12/2020