+ Reply to Thread
Results 1 to 2 of 2

Column Count in vloolup

  1. #1
    Registered User
    Join Date

    Column Count in vloolup

    I am trying to make life a little easier... I am sure there is a way to do this that I am not aware of..

    In a vlookup formula, example =vlookup(a$2,rangename,2,false) If the formula is to be copied to differebt columns it requiring a different column for the answer the "2" does not change... I have to go back and manually change them to the correct column number...

    Is there a way to make this be relative just as a cell reference would be without the $..

    Thank you Randy

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    Houston, TX
    MS-Off Ver
    It sounds like you have data in several columns, but want a VLOOKUP to find the same information for lookups in any of them, so that if you have San Diego, CA, and USA in A1:C1, and "United States" as the value to be returned in D1, you can use 5-Column() as the third argument. If I have misunderstood, could you please post a copy of the workbook?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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