Problem with Autofill when Using VLOOKUP Function
Hello, I'm having a little problem when trying to drag and drop a formula to autofill with the VLOOKUP function. I have a long list and I'm using this function to display the highest sales in rank order. Not sure if this is the best way to do it, but it's how I first learned how to do it. So my formula is this:
=VLOOKUP(LARGE($C$4:$C$10001,513),$C$4:$E$10001,3,FALSE).
What I would like for it to do is to have the 513 number to increment to 514 when I autofill to the next row. Then to 516, 517, etc. I have been manually changing this number the whole time, but it's a little tedious.
I have a similar problem with using this formula as well: =LARGE($C$4:$C$1002,513). As stated above, I'd like the 513 rank number to adjust to 514 when I autofill the next line. Here is a screen shot that might help to see what I have. The highlighted yellow cell is my VLOOKUP function and the cell to the right is my LARGE function:
Any help with this would be greatly appreciated. Thank you!