Apply the Vlookup formula and provide the explanation and the sheets for the best option for the candidate

ISSUE	OPTIONS	POINTS
Bonus	10%	0
8%	400
6%	800
4%	1200
2%	1600
Job Assignment	Division E	-2400
Division D	-1800
Division C	-1200
Division B	-600
Division A	0
Vacation Time	18 days	0
16 days	1000
14 days	2000
12 days	3000
10 days	4000
Starting Date	1-Jun	0
15-Jun	600
1-Jul	1200
15-Jul	1800
1-Aug	2400
Moving Expense Coverage	100%	0
90%	200
80%	400
70%	600
60%	800
Insurance Coverage	Plan A	0
Plan B	800
Plan C	1600
Plan D	2400
Plan E	3200
Salary	$120,000	-6000
$115,000	-4500
$110,000	-3000
$105,000	-1500
$100,000	0
Location	New York	0
Boston	300
Chicago	600
Atlanta	900
San Francisco	1200