+ Reply to Thread
Results 1 to 2 of 2

Vlookup; automatic lookup value help

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    Vlookup; automatic lookup value help

    Hello, im new to this forum and I'm also new to excel, just learning a little about the formulas, I have a question regarding VLookup, would really appreciate the help.

    I think I got how basic Vlookup works, but I want it to automatically get the lookup value... for this particular case, I want a formula I can paste on several rows, cause the table_array, col_index_num and range_lookup are always the same, but i have to manually select the lookup value as it keeps using the one I copied the formula from... I want the lookup value to be chosen from the left of where I am using the vlookup... this is the formula I have:


    This one I used on column/row H27, so the lookup value is I27, so I want to paste the foruma on lets say H40 and automatically make the lookup value to I40.

    Is there a way to do this?

    Thanks in advance for your time and help!

  2. #2
    Valued Forum Contributor
    Join Date
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010

    Re: Vlookup; automatic lookup value help

    If you copy the formula, it should update automatically since I27 is not an absolute address
    Click on star (*) below if this helps

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread


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