Upgrade from VLOOKUP to INDEX & MATCH

[Marvo]

Hi All, In the attached workbook, on the sheet entitled RESULTS, I use VLOOKUP to sort out the result after a golf competition using several criteria. It works fine, just have to keep changing the tables size when new players are added or deleted. I keep reading articles saying that using INDEX and MATCH is a superior way of doing things and I believe I could then take the data straight from the Master sheet without needing a table, but I don't know how or where to start. If somebody has a few minutes to take a look, I'd be grateful. Your advice maybe to stick with what I've got and I'm okay with that but I'm always looking to improve/modernise things.
Many Thanks.

[Pete_UK]

I use INDEX/MATCH a lot, but also VLOOKUP, and in your case I would suggest that you stick with VLOOKUP, although you could improve it slightly. For example, in B14 you have this:

=VLOOKUP($V14,data,3,0)

and this is copied across the next few columns with only the 3 changing (in turn to 4, 5, 6, 7 and 8). You could use:

COLUMNS($A:B)+1

instead of the 3, so that when you copy across the term will return the numbers that you want (therefore, you are only using one formula).

I've not really looked at other parts of your file.

Hope this helps.

Pete

[Marvo]

Thanks for the advice, Peter, I'll make those changes you suggest.

[Bo_Ry]

I would use this helper

U3
=MATCH(LARGE($W$3:$W$66,ROWS(U$3:U3)),$W$3:$W$66,)

Then B3:G3
=INDEX(Y$3:Y$66,$U3)

or With MS365

=SORTBY(Y3:AD66,W3:W66,-1)

[Marvo]

Sorry Bo_Ry, I didn't get notification of your post, only just seen it, I'll take a look. Many thanks.

[Marvo]

Had a chance to work on this Bo_Ry and many, many thanks, I've made a lot of changes based on your example. It's a bit of trial and error but everything is still working as it should so.... Super!