+ Reply to Thread
Results 1 to 2 of 2

Function to return value from each tab

  1. #1
    Steven Leuck
    Guest

    Function to return value from each tab

    I used to know how to do this. Can't seem to figure it out now.
    I would like an entry on my first spreadsheet tab to look up the same cell
    reference on each spreadsheet tab depending on my entry. Then entry would be
    the same as the tab name.
    Example: I have tabs named E1, E3, E5, E8, E9. If I imput "E1" into cell
    C4 on my first tab I would like cell g3 (also on my first tab) to tell me
    what is in cell c3 on the tab named "E1". Likewise, if change my entry to
    "E5", I would like cell G3 on my first tab to tell me what is in cell C3 on
    tab E5.

    I used to use =IF statements to do this with. But, Excel only allows 7
    nested =if statements and I have more tabs than that.

    Help is VERY appreciated.
    Steven Leuck

  2. #2
    Biff
    Guest

    Function to return value from each tab

    Hi!

    Try this in cell G3:

    =IF(C4="","",INDIRECT(C4&"!$C$3"))

    Biff

    >-----Original Message-----
    >I used to know how to do this. Can't seem to figure it

    out now.
    >I would like an entry on my first spreadsheet tab to look

    up the same cell
    >reference on each spreadsheet tab depending on my entry.

    Then entry would be
    >the same as the tab name.
    >Example: I have tabs named E1, E3, E5, E8, E9. If I

    imput "E1" into cell
    >C4 on my first tab I would like cell g3 (also on my first

    tab) to tell me
    >what is in cell c3 on the tab named "E1". Likewise, if

    change my entry to
    >"E5", I would like cell G3 on my first tab to tell me

    what is in cell C3 on
    >tab E5.
    >
    >I used to use =IF statements to do this with. But, Excel

    only allows 7
    >nested =if statements and I have more tabs than that.
    >
    >Help is VERY appreciated.
    >Steven Leuck
    >.
    >


+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1