Results 1 to 7 of 7

Find value in row and retrieve adjacent cell

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2014
    Location
    New York, NY
    MS-Off Ver
    Office 2010
    Posts
    13

    Find value in row and retrieve adjacent cell

    Hi Everyone,

    I'm having a problem that has been plaguing me for some time.

    I have a spreadsheet of Years, with the cost associated with each year for each particular entry (row). Each row has a different set of years in each column, but I am looking to return the amount for a specified year in just one column at the end.

    Before I confuse you more, maybe the attached spreadsheet will help explain.

    Lookup in Array.xlsx

    I have manually populated Column L to illustrate what I am trying to do. Does anyone happen to know a formula that can do this?

    Happy to answer any questions if I can help clarify.

    Thank you.
    Last edited by DigDoug; 09-11-2014 at 03:13 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to Find a Matching Pattern and Retrieve Data from the Adjacent Column
    By Saarang84 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 06-10-2014, 09:58 PM
  2. Macro to find cell value in column and retrieve duplicates
    By wwballar42 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2014, 06:45 PM
  3. Coding to Find Cell and Retrieve Row and Column Numbers
    By chaplaindoug in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2013, 01:18 PM
  4. To find the number of occurrences based on the cell condition and retrieve the value
    By rsundarmail77 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-02-2011, 11:50 AM
  5. [SOLVED] Macro to find and retrieve cell contents
    By DancingElvisLives in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2011, 09:33 AM

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