The sales manager is working on a large order data set and wants to extract meaningful information for analysis.

For a list of OrderIDs given in the range G63:G66, he would like to know Invoice Payment Status, sales amount & Delivery Date

Order details are in the cell range A63:E78

In cell H63, write a formula using VLOOKUP function only, write an array formula (that is enter multiple column number in the col_index_num) to find all

the required columns viz. Invoice Payment Status, Sales Amount($) and Delivery Date for the OrderID given in G63.

Copy the formula down to H66.

Use cell reference for the Order ID; dont hardcode it in the formula.

OrderID	Salesperson	Delivery Date	Sales amount ($)	Invoice Payment Satus
89	Bailey Cunningham	4-Oct-20	665	Not Paid
90	Brenden Calderon	6-Oct-20	654	Paid
57	Owen Smith	4-Oct-20	523	Not Paid
100	Owen Smith	6-Oct-20	630	Paid
51	Owen Smith	4-Oct-20	686	Not Paid
87	Bailey Cunningham	3-Oct-20	521	Paid
54	Bailey Cunningham	3-Oct-20	618	Paid
73	Bailey Cunningham	6-Oct-20	524	Not Paid
70	Brenden Calderon	3-Oct-20	685	Paid
55	Bailey Cunningham	6-Oct-20	560	Not Paid
79	Bailey Cunningham	5-Oct-20	610	Not Paid
93	Brenden Calderon	3-Oct-20	543	Not Paid
52	Owen Smith	3-Oct-20	603	Paid
92	Brenden Calderon	5-Oct-20	500	Not Paid
63	Meredith Palmer	4-Oct-20	552	Not Paid
88	Brenden Calderon	3-Oct-20	623	Not Paid

OrderID	Invoice Payment Status	Sales amount ($)	Delivery Date
57
52
88
79

CORRECT ANSWER:

OrderID Sales Amount ($) Delivery Date Invoice Payment Satus 57 Not Paid 52 Paid 88 Not Paid 79 Not Paid 523 603 623 610 4-Oct-20 3-Oct-20 3-Oct-20 5-Oct-20 OrderID Sales Amount ($) Delivery Date Invoice Payment Satus 57 Not Paid 52 Paid 88 Not Paid 79 Not Paid 523 603 623 610 4-Oct-20 3-Oct-20 3-Oct-20 5-Oct-20