Results 1 to 3 of 3

VLOOKUP / INDEX / MATCH Function??

Threaded View

liverpoolphil VLOOKUP / INDEX / MATCH... 10-08-2009, 08:35 AM
DonkeyOte Re: VLOOKUP / INDEX / MATCH... 10-08-2009, 09:13 AM
liverpoolphil Re: VLOOKUP / INDEX / MATCH... 10-08-2009, 09:30 AM
  1. #1
    Registered User
    Join Date
    02-18-2009
    Location
    Lancashire, England
    MS-Off Ver
    Excel 2003
    Posts
    21

    VLOOKUP / INDEX / MATCH Function??

    hope you can help

    I am trying to match data from 2 independent sets, formatted slightly differently so not sure which function would work best for me

    From the attached file, I am trying to match the date and time stamp (in cell A1) with that from the other data (in this example in cell E1) and return the data (from cell F1) to cell C1

    So basically any date and time stamp before 04/03/09 04:00 will return a value of 44 (this value should appear, therefore in cells C1 - C30)

    Hope this makes sense

    Phil
    Attached Files Attached Files
    Last edited by liverpoolphil; 10-08-2009 at 10:02 AM.

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