Results 1 to 4 of 4

How to display contents(text) of a cell referenced by a given cell

Threaded View

  1. 02-09-2009, 11:05 AM #1
    bmind
    bmind is offline
    Registered User
    Join Date
    02-09-2009
    Location
    Winnipeg, Canada
    MS-Off Ver
    Excel 2003
    Posts
    49

    How to display contents(text) of a cell referenced by a given cell

    I want to display the contents of cell B5 in A7 by using cell C7 to show the location of the cell to be displayed. Cell C7 has a formula that shows the cell location of information (text) that needs to be displayed. How can I show in A7 the contents of cell reference shown in C7? In figure attached I show an example to better understand.
    Want in A7 to show the contents of B5 by reading what is in C7. So A7 cell should show word Road.
    Thanks,
    Attached Images Attached Images
    Last edited by bmind; 02-09-2009 at 11:52 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1