+ Reply to Thread
Results 1 to 3 of 3

Vlookup inconsistent formula

  1. #1
    Registered User
    Join Date
    06-17-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    9

    Vlookup inconsistent formula

    Hi All,

    I am trying to drag a vlookup formula across several cells and eventially over thousands. However i cant seem to get a consistant sequential formula the way i want it.

    I have attached my document to this post.

    for example in cell AG i have this

    =VLOOKUP(N1,INDIRECT(A2),2,FALSE)*N2

    as i drag this across to cell AH the INDIRECT(A2) changes, i want it to remain (A2). However when i want to drag the formula down to the next cell i want it to change to INDIRECT(A3).. and so forth.

    Can someone help me to achieve this please? or give me some better ideas.


    thanks

    Aboo
    Attached Files Attached Files

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Vlookup inconsistant formula. any ideas?

    Hello,

    use absolute instead of relative references.

    =VLOOKUP(N1,INDIRECT($A2),2,FALSE)*N2

    With the $A the column reference will stay A when dragged across, but the row reference will adjust when dragged down.

    cheers,

  3. #3
    Registered User
    Join Date
    06-17-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Vlookup inconsistant formula. any ideas?

    Hi Teylyn,

    Thankyou for your reply, this will work when im dragging the forumla across, however when i want to drag the formula down i want N1 reference to stay and if i drag across i want the N1 reference to change to O1, how can i achieve this?

    Thank you for your help

+ 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