Forum Discussion
PedroDerek
May 17, 2024Copper Contributor
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 or...
HansVogelaar
May 17, 2024MVP
Since you already have the sequence number 513 in cell F516, you can use
=VLOOKUP(LARGE($C$4:$C$10001,F516),$C$4:$E$10001,3,FALSE)
Alternatively, you could use
=VLOOKUP(LARGE($C$4:$C$10001,ROW(G516)-3),$C$4:$E$10001,3,FALSE)
- PedroDerekMay 17, 2024Copper ContributorSuch a simple fix and this will be saving me so much time in the future! Thank you so much for your expertise and timely response!