Results 1 to 2 of 2

Excel 2007 : Return a value from another worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    08-28-2009
    Location
    Kansas
    MS-Off Ver
    Excel 2003
    Posts
    6

    Return a value from another worksheet

    EXCEL 2007 -in the same workbook but on a different worksheet I want to return a value - example if column A = RVDB and column B = 2/1/2010 - I want the fomula to return the value of the cell 5.33

    Example
    Worksheet name TGT
    Column A - Org
    Column B - Date
    Column C - Target

    A B C
    1 RVDB 1/1/2010 4.55
    2 RVDB 2/1/2010 5.33
    3 RVJJ 1/1/2010 4.22
    4 RVJJ 2/1/2010 3.39
    Last edited by NMJones; 01-21-2011 at 02:04 PM. Reason: add excell version 2001

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