+ Reply to Thread
Results 1 to 3 of 3

Lookup Function to Return Values in Adjacent Cell?

  1. #1
    Registered User
    Join Date
    04-29-2011
    Location
    Cincinnati, OH
    MS-Off Ver
    Excel 2007
    Posts
    12

    Lookup Function to Return Values in Adjacent Cell?

    Not sure if I'm wording this correct but basically what I'm trying to accomplish is:

    Source:

    Please Login or Register  to view this content.
    I'm trying to find a formula that would allow me to LOOKUP value in COLUMN1 (COL1 above) and then return the values in COLUMN2 (COL2 above). So in the above example Lookup ABC, returns 1, 32, 23, 14 (but in the same layout as above, vertically).

    Sure I'm missing something simple here. Thanks in advance.

  2. #2
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    552

    Re: Lookup Function to Return Values in Adjacent Cell?

    Index() Using Match to find ABC then use increments of +1 to return the numbers next to it.
    If someone helped give them rep using the star button.

    If you have received a satisfactory solution please mark the thread solved. If not Fotis will come for you at night :P

  3. #3
    Registered User
    Join Date
    04-29-2011
    Location
    Cincinnati, OH
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Lookup Function to Return Values in Adjacent Cell?

    Thank you. Not sure why it didn't click to use Index/Match. Worked perfectly.

+ 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