+ Reply to Thread
Results 1 to 2 of 2

Indirect Cell Reference

  1. #1
    Registered User
    Join Date
    03-17-2010
    Location
    Sebastopol, MS
    MS-Off Ver
    Excel 2007
    Posts
    14

    Indirect Cell Reference

    Okay, I have a formula which returns the text "D4".
    It looks a little something like this:

    ="D"&MATCH(A1,C1:C5,0)

    I want it to find the text in A1 in my list in column C, and give me the corresponding value from column D. Can I get it to display the contents of cell D4, rather than saying "D4"?
    Is there a way to go about doing this just in a formula? I don't want to have to use a program, or visual basic or anything like that. Thank you anyone who can help.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Indirect Cell Reference

    I would opt for:

    Please Login or Register  to view this content.
    alternatively

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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