Hey, just made an account here so sorry if I'm not understanding everything properly. There's a few things I'm having trouble with and wanted to see if I could get some answers. I normally use excel but I need to use Google Sheets for this because it's something I want people to be able to access and read online whenever. Anyways, I am using vlookup for the first time and understand it a little better now, but not completely. I'm using "named ranges" as a way to access the range I need more quickly.
I'm making a standings system based off a list of means. My first guess is to make a ranking system and then use vlookup to order everything automatically on another tab. First question:
If 2 people have the same average score, they're tied. I have 2 people tied for second. I would like for the ranking to list both of them, but I don't want them to have their own unique rank. I don't know how to do this without getting an error. I would simply like the spreadsheet's first 3 rows to show 1st place, 2nd place, and the different 2nd place (without listing it as 3rd, using countif)
My next issue is how to copy (fill) the cells downward when using vlookup. I would like to fill in this way:
VLOOKUP(1,namedrange,1,FALSE)
VLOOKUP(2,namedrange,1,FALSE)
VLOOKUP(3,namedrange,1,FALSE)
but I have no clue how to get only the row number to change. If I could get a solution that allows me to continue using my named range, I would heavily prefer that also.
Hope everything as explained clearly, thanks in advance.
I'm making a standings system based off a list of means. My first guess is to make a ranking system and then use vlookup to order everything automatically on another tab. First question:
If 2 people have the same average score, they're tied. I have 2 people tied for second. I would like for the ranking to list both of them, but I don't want them to have their own unique rank. I don't know how to do this without getting an error. I would simply like the spreadsheet's first 3 rows to show 1st place, 2nd place, and the different 2nd place (without listing it as 3rd, using countif)
My next issue is how to copy (fill) the cells downward when using vlookup. I would like to fill in this way:
VLOOKUP(1,namedrange,1,FALSE)
VLOOKUP(2,namedrange,1,FALSE)
VLOOKUP(3,namedrange,1,FALSE)
but I have no clue how to get only the row number to change. If I could get a solution that allows me to continue using my named range, I would heavily prefer that also.
Hope everything as explained clearly, thanks in advance.