+ Reply to Thread
Results 1 to 5 of 5

VLookup Specific Entry

  1. #1
    Registered User
    Join Date
    10-23-2019
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    5

    VLookup Specific Entry

    Hi

    Can I use a vlookup to look at a column but only drag across a specific piece of information i.e one persons name? instead of just lookup everything in the column? Thanks

    Regards

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,093

    Re: VLookup Specific Entry

    I'm a bit confused with your description so I'm going more by your post title.
    this will lookup a specific value in A2 and will stay locked on A2 regardless of if you drag the formula to the right...
    =VLOOKUP($A$2,B:C,2,FALSE)
    this will lookup a specific name that won't change if you drag the formula to the right...
    =VLOOKUP("John Doe",A:B,2,FALSE)
    this will look up a value locked in one cell and will look to the right as it is dragged right...
    =VLOOKUP($A$2,$B:C,COLUMN(B$1),FALSE) and will index toward the right as you drag it but staying on column B.
    are any of those what you are looking for?
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    10-23-2019
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    5

    Re: VLookup Specific Entry

    Hi Sam

    thanks for your help

    Effectively I need the second option there but in reverse, have a column of Names which i need to match against a specific individual in another list. I.e of how many clients in the list the Sales person X meet.

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,093

    Re: VLookup Specific Entry

    could you follow the banner at the top and upload a workbook with a representative example and expected results so I know what you mean?

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,093

    Re: VLookup Specific Entry

    is what you are looking for an index/match but that you want to drag it to the right and have it move left?

+ 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. Replies: 2
    Last Post: 04-16-2019, 10:04 AM
  2. [SOLVED] Confirm if last entry in a row is specific data
    By citadel-maritime in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-16-2015, 10:28 AM
  3. [SOLVED] Vlookup to return specific value if cell value of vlookup is specific
    By shaz0503 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-24-2015, 10:36 PM
  4. [SOLVED] Vlookup in UserForm - Get Input from listbox, Lookup in specific table from specific sheet
    By s2jrchoi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-30-2013, 09:00 AM
  5. Replies: 3
    Last Post: 07-06-2011, 08:25 PM
  6. Last entry of specific value in formula...?
    By JeyPey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-08-2008, 03:26 PM

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