+ Reply to Thread
Results 1 to 2 of 2

Use formula to find cell number, before referencing it?

  1. #1
    Registered User
    Join Date
    10-16-2014
    Location
    Canada
    MS-Off Ver
    2014
    Posts
    3

    Question Use formula to find cell number, before referencing it?

    Let's say I want to use an item from a cell I don't know yet, but I can find the number with a formula, which turns out to be 6 at one instance, is it possible to call A6 like this?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,123

    Re: Use formula to find cell number, before referencing it?

    Hi, welcome to the forum

    If you already know what the 6 will be, but that it may change, you could probably use the INDIRECT() function. Something like this...

    =INDIRECT("A"&6)
    you could either hardcode 6 or reference it from another cell

    However, I have a feeling that you also probably use 1 of the regular built-in lookup functions for this, such as vlookup or index/match.

    If you give more detail then perhaps we can put something together for you?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. [SOLVED] Formula/s to find a certain number in a group/cell and then do calculations.
    By hammer2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2013, 07:49 PM
  2. Formula help, Require to find Min and max of time referencing another cell
    By arekkusu03 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2013, 08:33 PM
  3. Replies: 3
    Last Post: 05-19-2013, 09:07 AM
  4. Formula referencing a cell using a number of another cell
    By PAUL41EXCEL in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-20-2013, 03:03 AM
  5. [SOLVED] Need to find a formula to extract a number out of a cell that also has letters
    By Cassi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-25-2013, 09:39 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