+ Reply to Thread
Results 1 to 3 of 3

Referencing help

  1. #1
    Registered User
    Join Date
    07-23-2015
    Location
    England
    MS-Off Ver
    2010
    Posts
    1

    Referencing help

    Hi, I would be grateful if anybody could help me please.

    I wish to populate a cell in Sheet1 with the sum of the last value in columns from Sheet2 and Sheet3.

    However, the column from Sheet2 and Sheet3 for this formula needs to be identified by Excel by matching an identifying number from Column A of Sheet1 (adjacent to the destination cell) to the same identifying number in Row 1 of Sheet2 and Sheet3.

    I have tried to attach a simple example document where I have shown the sum that would give the right result in the right place.

    In practice the data in Sheet2 and Sheet3 will not be the same width/height as one another and there will be a larger number of worksheets from which Sheet1 would need to reference from.
    Attached Files Attached Files

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: Referencing help

    B2:
    Please Login or Register  to view this content.
    Copy over and down as needed.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Referencing help

    Or possibly:

    Please Login or Register  to view this content.
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

+ 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. Converting VBA language referencing LotusNotes to language referencing Outlook
    By adubberkegreen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2015, 05:12 AM
  2. Replies: 0
    Last Post: 01-09-2013, 06:58 AM
  3. Excel 2007 : 3D referencing
    By NGH09 in forum Excel General
    Replies: 1
    Last Post: 10-19-2010, 03:00 PM
  4. VBA Referencing 2
    By RBI in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-02-2008, 05:25 AM
  5. Lookup referencing cell referencing range
    By cmcconnehey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-15-2008, 06:19 PM
  6. [SOLVED] Referencing
    By Paul W Smith in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-29-2006, 02:55 PM
  7. 3-D referencing
    By YBeaupre in forum Excel General
    Replies: 0
    Last Post: 09-04-2005, 04:05 PM
  8. Help with referencing please
    By clueless_05 in forum Excel General
    Replies: 2
    Last Post: 06-01-2005, 09:44 AM

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