+ Reply to Thread
Results 1 to 6 of 6

vlookup of adjacent cells

  1. #1
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    vlookup of adjacent cells

    I am looking to populate two additional cells that provide information beside my vlookup column. I have attached a simple version of what I am trying to do however the drop down list will be on a different page from the data
    Thanks for any help.
    Attached Files Attached Files
    Southwest Granite & Glass
    Quality, It's what we do
    http://www.swgg.ca

  2. #2
    Registered User
    Join Date
    09-02-2013
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2013
    Posts
    44

    Re: vlookup of adjacent cells

    Do you want to retrieve the "w" corresponding to sink ID, and the "h" corresponding to the same id?

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: vlookup of adjacent cells

    Hi,

    It's not at all clear (at least to me) what it is you're trying to achieve.
    What do YOU mean by a drop down, what values should it contain and how should it be used.
    It's not clear what your Vlookup() function looks like nor where it is.

    In any case this is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

    Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: vlookup of adjacent cells

    Quote Originally Posted by anghicole View Post
    Do you want to retrieve the "w" corresponding to sink ID, and the "h" corresponding to the same id?
    that is exactly what i am looking for

  5. #5
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: vlookup of adjacent cells

    richard,
    perhaps this will help explain better. My list is hundreds of pieces long and will grow daily but the parameters will always be the same
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    09-02-2013
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2013
    Posts
    44

    Re: vlookup of adjacent cells

    Is this waht you need?
    Attached Files Attached Files

+ 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. [SOLVED] Help with Vlookup plus adding a user-input number of adjacent cells
    By rham243 in forum Excel General
    Replies: 2
    Last Post: 08-10-2015, 04:39 PM
  2. Replies: 3
    Last Post: 07-21-2015, 05:10 PM
  3. [SOLVED] How to copy value of adjacent cells to non-adjacent cells
    By mgoutam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-22-2014, 04:35 PM
  4. [SOLVED] Concatenating adjacent and non adjacent cells depending on entries
    By TBHusker84 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2013, 10:27 AM
  5. VLOOKUP to find multi results and sum adjacent cells
    By Phatmat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-11-2013, 09:35 PM
  6. Replies: 3
    Last Post: 07-30-2012, 11:20 AM
  7. Adjacent cells in non-adjacent list?
    By anakeimai in forum Excel General
    Replies: 3
    Last Post: 09-10-2008, 05:49 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