Please Explain this Vlookup Formula?

[killz]

I want to know why this vlookup formula works. Heres the formula:

=SUM(LARGE(VLOOKUP(E9,$A$2:$D$5,{2;3;4},0),{1;2}))

Here are my questions:

1) Why is $A$2:$D$5 in absolute reference?

2) Why are there semi-colons between the values? Why not commas?

​

Book1
	A	B	C	D	E
1	Thrower	Throw 1	Throw 2	Throw 3	Thrower
2	Daniel	45,99	23,78	51,02	Daniel
3	Richard	40,22	42,32	43,69	Richard
4	Matt	37,55	34,2	31,5	Matt
5	Stevie	69,43	0	56,11	Stevie
Sheet1

 

[jtakw]

Hi,

markmzz already explained his formula in Detail in the thread where you copied the formula from, didn't you see Post #33 and Post #35 from this thread: https://www.mrexcel.com/forum/excel...summed-value-2-largest-numbers-vlookup-4.html