+ Reply to Thread
Results 1 to 2 of 2

Comparing values from different sheets and inserting value from same row

  1. #1
    Registered User
    Join Date
    02-17-2010
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    3

    Exclamation Comparing values from different sheets and inserting value from same row

    I have a database of temperatures sorted chronologically on sheet 2 column A = dates, column B = temperature. I have certain dates on sheet 1 that correspond to dates of events. How can I insert the temperature based on sheet 2 (temperature database) that correspond to the date of the event.

    SHEET 1

    A B
    DATE TEMP
    Jan 1 ?
    Feb 5 ?
    Mar 6 ?

    SHEET 2
    A B
    DATE TEMP
    Jan 1 10
    Jan 2 12
    Jan 3 15
    ... ... etc.

  2. #2
    Registered User
    Join Date
    02-17-2010
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Comparing values from different sheets and inserting value from same row

    found it =vlookup function...

+ 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