+ Reply to Thread
Results 1 to 2 of 2

Making dynamic vlookup

  1. #1
    Registered User
    Join Date
    03-02-2016
    Location
    Utrecht
    MS-Off Ver
    7
    Posts
    1

    Making dynamic vlookup

    In the following formula:

    =ALS(VERT.ZOEKEN(A19;Keywords!$A$2:$H$10;KOLOM();ONWAAR)="";"";VERT.ZOEKEN(A19;Keywords!$A$2:$H$10;KOLOM();ONWAAR))

    I want to repace A19 by a formula like: "A" & ROW()+ 1, making:

    =IF(VLOOKUP("A" & ROW()+1;Keywords!$A$2:$H$10;COLUMN();FALSE)="";"";VLOOKUP(A19;Keywords!$A$2:$H$10;COLUMN();FALSE))

    When I try the formula is a separate cell, it works. In the vlookup formula, it doesn't.


    The question is: why????

    Thanks for answering

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,947

    Re: Making dynamic vlookup

    You need to replace

    "A" & ROW()+1

    with

    INDIRECT("A" & ROW()+1)

    or

    INDEX("A:A",ROW()+1)


    but using A19 will give you the same result when you copy it down, since "A" & ROW() +1 will update the same way that A19 would (if the formula is in row 18, for example).
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. help with making years dynamic
    By ammartino44 in forum Excel General
    Replies: 2
    Last Post: 09-12-2015, 05:51 PM
  2. Making cells dynamic
    By NaomiDawn in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-31-2013, 09:21 AM
  3. making macro dynamic
    By rexer231 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2013, 03:48 AM
  4. Making graphs dynamic
    By Mick Butler in forum Excel General
    Replies: 3
    Last Post: 03-30-2012, 04:50 AM
  5. help with making a dynamic variable
    By squeekee35 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2011, 11:01 AM
  6. Making a spreadsheet dynamic
    By holla in forum Excel General
    Replies: 4
    Last Post: 09-10-2009, 12:27 PM
  7. Making condition dynamic?
    By aposatsk in forum Excel General
    Replies: 3
    Last Post: 08-16-2006, 08:43 AM

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