I created a VLOOKUP formula inside a Google Sheet, I have 130000 lines and need to extend the formula to the end of the column.

  • This is the formula I'm using: =VLOOKUP(A10;$B$2:$C$4;2;0)
    – Nesaia
    May 4 at 4:35
  • I tried also to use =Arrayformula(=VLOOKUP(A10;$B$2:$C$4;2;0)) but it is not working
    – Nesaia
    May 4 at 4:35

1 Answer 1


First Solution: ARRAYFORMULA

This modified formula should work:


Second Solution: Fill Down

Select the entire column you wish this formula to be in, make sure that the first cell has the formula in it, then press Ctrl + D. This should copy down the formula.

Also for the time you ask questions, please key all the information in the actual question. You can edit your question if you have extra information that you forgot to mention.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.