Complete the following question in the yellow cell by using the
Data Tab.
1. Input a Vlookup formula in the yellow cell and determine the
Due Date for Order ID # 4. Change date format to show
dd-mmm-yy
Order ID Product Category Amount Due Date Country 1 Carrots Vegetables 4270 1/6/2012 United States 2 Broccoli Vegetables 8329 1/7/2012 United Kingdom 3 Banana Fruit 617 1/8/2012 United States 4 Banana Fruit 8384 1/10/2012 Canada 5 Beans Vegetables 2626 1/10/2012 Germany 6 Orange Fruit 3610 1/11/2012 United States 7 Broccoli Vegetables 9062 1/11/2012 Australia 8 Banana Fruit 6906 1/16/2012 New Zealand 9 Apple Fruit 2417 1/16/2012 France 10 Apple Fruit 7131 1/16/2012 Canada
Order ID Due Date 4
Complete the following question in the yellow cell by using the Data Tab. 1. Input a Vlookup formula in the yellow cell
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am