Below is select sales data for RX Industries. The orders range from 1 to 20, however any returned or canceled orders have been deleted from the data. Use the template below to create an order summary that automatically shows the data for any selected order ID between 1 and 20. Hint: Use the IFERROR and HLOOKUP functions. The function for any order ID in the range that has been deleted should return the phrase "Not Found."
| OrderID |
1 |
7 |
9 |
13 |
16 |
2 |
3 |
| Region |
East |
East |
East |
East |
East |
West |
West |
| OrderDate |
1/10/2009 |
3/6/2009 |
3/28/2009 |
4/8/2009 |
4/12/2009 |
5/16/2009 |
5/23/2009 |
| OrderAmt |
$1,122.00 |
$ 4,453.00 |
$ 1,305.00 |
$2,708.00 |
$1,502.00 |
$4,796.00 |
$1,526.00 |
| 5 |
10 |
14 |
4 |
8 |
11 |
17 |
18 |
| West |
West |
West |
Central |
Central |
Central |
Central |
Central |
| 6/2/2009 |
7/8/2009 |
7/30/2009 |
8/29/2009 |
9/9/2009 |
10/5/2009 |
11/16/2009 |
12/25/2009 |
| $1,523.00 |
$2,068.00 |
$1,597.00 |
$ 781.00 |
$2,976.00 |
$4,145.00 |
$3,979.00 |
$2,044.00 |