+ Reply to Thread
Results 1 to 3 of 3

vlookup function addressing

  1. #1
    jacky.newsgroup@gmail.com
    Guest

    vlookup function addressing

    Hi,

    I would like to use this:
    +vlookup(value, data range, col, false)

    data range = start position:B20

    the value of the start position is stored in cell D1, it is
    "calculated" by some functions and put into cell D1

    how do i used vlookup to use the start position in D1 automatically? i
    do not want to type it manually


  2. #2
    Harlan Grove
    Guest

    Re: vlookup function addressing

    jacky.newsgroup@gmail.com wrote...
    >I would like to use this:
    >+vlookup(value, data range, col, false)
    >
    >data range = start position:B20
    >
    >the value of the start position is stored in cell D1, it is
    >"calculated" by some functions and put into cell D1
    >
    >how do i used vlookup to use the start position in D1 automatically? i
    >do not want to type it manually


    You could use

    INDIRECT(D1):B20

    as data range, but you may be better off using

    INDEX($A:$B,row expression,column expression)

    where the row and column expressions would be similar to the formulas
    you're using to produce your D1 value.


  3. #3
    jacky.newsgroup@gmail.com
    Guest

    Re: vlookup function addressing

    thanks Harlan!

    i've been messing around for a few hours on this!


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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