cell reference based on value in another cell

Posted on 2011-05-11
Last Modified: 2012-05-11
I think this should be easy, but I can't figure out quite how to do it.

Here is a simple representation

     A     B     C     D     E
1   2                   2
2   4
3   6
6    x
In the cell A6 I need a function that returns the value in A1, A2 or A3 depending on the value of the relevant row in D1.

eg If D1 = 1 A6 is the value in A1.  If D1 = 3 A6 is the value in A3. etc

What is the easiest way of indicating a row reference based on the value in a given cell?

Best regards

Question by:rltomalin
    LVL 85

    Accepted Solution

    should work.
    LVL 6

    Assisted Solution

    Try this formula:
    LVL 43

    Assisted Solution

    by:Saqib Husain, Syed


    Author Closing Comment

    Thanks for the input.  All three solutions are clear and do the job.  I just chose one of course - shared points equally.


    LVL 43

    Expert Comment

    by:Saqib Husain, Syed
    Which one? ;-)

    Thanks for the points

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now