ON EXCEL Use VLookup function in this question

Insurance Bonus Awards
Parameters			Total Bonus Amount Available	$500,000
Bonus Points to be awarded for percentage above target sales.
	Lower Limit	Upper Limit	Bonus Points
	0%	10%	0
	11%	30%	5
	31%	50%	10
	51%	79%	15
	80%	99%	25
	100%	10000%	40
Model
Employee ID	% Above Target Sales	Bonus Points	Bonus Amount
Employee1	63%
Employee2	5%
Employee3	18%
Employee4	44%
Employee5	20%
Employee6	26%
Employee7	70%
Employee8	48%
Employee9	68%
Employee10	62%
Employee11	20%
Employee12	62%
Employee13	95%
Employee14	29%
Employee15	11%
Employee16	85%
Employee17	21%
Employee18	31%
Employee19	18%
Employee20	41%
Employee21	95%
Employee22	14%
Employee23	56%
Employee24	85%
Employee25	12%
Employee26	130%
Employee27	65%
Employee28	75%
Employee29	19%
Employee30	70%
Employee31	31%
Employee32	18%
Employee33	41%
Employee34	75%
Employee35	14%
Employee36	36%
Employee37	45%
Employee38	12%
Employee39	30%
Employee40	65%
Employee41	75%
Employee42	19%
Employee43	40%
Employee44	18%
Employee45	44%
Employee46	20%
Employee47	26%
Employee48	70%
Employee49	48%
Employee50	68%
Employee51	62%
Employee52	20%
Employee53	62%
Employee54	35%
Employee55	29%
Employee56	11%
Employee57	85%
Employee58	101%
Employee59	68%
Employee60	62%
Employee61	21%
Employee62	95%
Employee63	14%
Employee64	56%
Employee65	85%
Employee66	12%
Employee67	90%
Employee68	65%
Employee69	75%
Employee70	19%
Employee71	70%
Employee72	31%
Employee73	20%
Employee74	62%
Employee75	35%
Employee76	44%
Employee77	20%
Employee78	26%
Employee79	70%
Employee80	48%
Employee81	68%
Employee82	62%
Employee83	20%
Employee84	62%
Employee85	35%
Employee86	29%
Employee87	11%
Employee88	81%
Employee89	21%
Employee90	18%
Employee91	21%
Employee92	95%
Employee93	14%
Employee94	56%
Employee95	85%
Employee96	18%
Employee97	31%
Employee98	65%
Employee99	14%
Employee100	36%
	Total