Below are a list of potential capital budgeting projects for DVX Inc.

Create a vlookup which will populate the list of projects to be selected based on the following criteria. 1. Populate the Include column to indicate which project from each region should be selected, based on the project in each region with the highest NPV. If functions may be useful in this step.

2. Use the vlookup to insert the project number, cost, and NPV of the selected project from each region into the table.

DVX Inc.
Optimal Capital Budget
Under Capital Rationing
Include	Region	Project	Cost	NPV
	Europe	1	$1,200,000	$172,036
	Europe	2	$2,000,000	$362,283
	Europe	3	$500,000	$147,487
	Asia	4	$600,000	$72,076
	Asia	5	$700,000	$129.35
	Asia	6	$3,000,000	$527,127
	Asia	7	$1,500,000	$343,632
	Africa	8	$200,000	$52,836
	Africa	9	$2,400,000	$275,936
	Africa	10	$1,000,000	$175,824
		Project	Cost	NPV
	Europe
	Asia
	Africa

Please provide Excel formula too!