+ Reply to Thread
Results 1 to 3 of 3

Referencing cell text data in another formula

  1. #1
    Registered User
    Join Date
    10-07-2014
    Location
    Turkey
    MS-Off Ver
    2013
    Posts
    4

    Referencing cell text data in another formula

    Hmm, bit stuck here. Thought I had it using INDIRECT but alas not. Anyone have any advice? I'm no expert, so be gentle with me... Thanks in anticipation

    Column B has cells containing numeric values.
    I want to include the value of a column B cell within a formula that references rows of another worksheet.

    Eg.

    Cell B4 contains the value 76
    In cell C4, I want to effectively use the formula ='ABC SHEET'!B76 but the value 76 should actually be derived from the value in cell B4

    So if cell B7 contains the value 888, the formula should effectively do the following.... ='ABC SHEET'!B888 but again with the value 888 actually coming from cell B7
    Last edited by Farmer Ali; 10-07-2014 at 06:41 AM.

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Referencing cell text data in another formula

    =INDIRECT("'ABC SHEET'!B"&B4)
    Try this
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    10-07-2014
    Location
    Turkey
    MS-Off Ver
    2013
    Posts
    4

    Re: Referencing cell text data in another formula

    Brilliant.... thanks so much, saved my some head-scratching today

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 09-18-2014, 05:41 PM
  2. [SOLVED] Count # of times text appears in cell range by cell referencing not =countif(A:A, ="text")
    By smit.etha in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-20-2014, 04:09 AM
  3. [SOLVED] Referencing cell value or text within a formula
    By BPSJACK in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-28-2012, 12:14 PM
  4. [SOLVED] Referencing text within a formula to locate the data used within that formula
    By bishbash89 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-01-2012, 06:38 AM
  5. Referencing text in a cell in a formula
    By jimbob in forum Excel General
    Replies: 3
    Last Post: 02-27-2006, 07:15 PM

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