Share via

Fill Vlookup formula down a column

Anonymous
2025-03-12T14:59:34+00:00

I am working on a formula that is matching Zip Codes in one column (column A) and comparing it to an array of a Zip Codes and Account reps (column B and C) and in Column D it will show the Account rep that is assigned based on the array in columns B&D.

This is the vlookup formula I have:
=VLOOKUP(A2, B2:$C$19, 2, FALSE)

How do I copy the formula down so that the A number serializes (A2, A3, A4, A5, etc...) and keep the rest of the formula (B2:$C$19, 2, FALSE) the same?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2025-03-12T15:09:10+00:00

    Dear respected Samantha Nwaoshai,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    As per your description, you can modify your formula as follows:

    =VLOOKUP(A2, $B$2:$C$19, 2, FALSE)

    When you drag the formula down, the reference to A2 will change to A3, A4, A5, and so on automatically, while the reference to the array in columns B and C ($B$2:$C$19), the column number (2), and the match type (FALSE) will remain constant.

    If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

    Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

    Appreciate your patience and understanding and thank you for your time and cooperation.

    Sincerely,

    Waqas Muhammad

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-03-12T15:11:12+00:00

    Never mind. I saw that column B is not absolute so it wasn't copying correctly. I fixed the formula and now it works.

    =VLOOKUP(A2, $B$2:$C$19, 2, FALSE)

    Was this answer helpful?

    0 comments
  2. HansV 462.6K Reputation points
    2025-03-12T15:08:10+00:00

    =VLOOKUP(A2, $B$2:$C$19, 2, FALSE)

    The $ signs make a cell reference absolute, i.e. fixed.

    Was this answer helpful?

    0 comments