+ Reply to Thread
Results 1 to 2 of 2

How to repeat formula without changing table array

  1. #1
    Registered User
    Join Date
    10-30-2017
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    7

    Question How to repeat formula without changing table array

    Hi. How does on repeat this formula down a column, without changing the table array numbers?

    I want this:
    =VLOOKUP(A2,C2:D100,2,FALSE)
    =VLOOKUP(A3,C2:D100,2,FALSE)
    =VLOOKUP(A4,C2:D100,2,FALSE)
    =VLOOKUP(A5,C2:D100,2,FALSE)

    But right now I end up with this:
    =VLOOKUP(A2,C2:D100,2,FALSE)
    =VLOOKUP(A3,C3:D101,2,FALSE)
    =VLOOKUP(A4,C4:D102,2,FALSE)
    =VLOOKUP(A5,C5:D103,2,FALSE)

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: How to repeat formula without changing table array

    =vlookup($a2,$c$2:$d$100,2,false)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to use VLOOKUP with changing table array
    By 4sp1r3 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-08-2020, 05:37 AM
  2. Array Formula - Doesn't Repeat
    By laurenm in forum Excel General
    Replies: 1
    Last Post: 10-30-2018, 07:41 PM
  3. [SOLVED] Repeat a formula 5 times before changing cell reference
    By amartin575 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-28-2014, 04:11 PM
  4. Vlookup with a changing table array
    By jnicflo in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-05-2013, 04:59 PM
  5. Automatically changing a Table Array in a Vlookup
    By roasty_1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-11-2008, 12:07 PM
  6. changing the table array in a vlookup
    By sail0017 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-08-2007, 04:15 PM
  7. i want to do a vlookup but i want the table array to be changing
    By dimitris in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2006, 06:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1