+ Reply to Thread
Results 1 to 5 of 5

Pull data based on date match

  1. #1
    Registered User
    Join Date
    01-06-2012
    Location
    MN
    MS-Off Ver
    Excel 2013
    Posts
    62

    Pull data based on date match

    I have a spreadsheet where I pull in commodity price data (seperate tab by commodity) - this is working but I cannot figure out how to summarize the information onto one sheet. I would like for the program to pull in the commodity prices listed in the "Last" column (E) of Corn, SBM and LEan Hogs into the correct month on the summary sheet. For example, cell C17 on Summary would be $6.435 (from Corn CBOT cell E3). Cell C19 on Summary would be $6.5075 (from Corn CBOT cell E5) and so on for all the commodities and months.

    The data from the web is not formatted such that I can use Vlookups. The pricing data comes in using fractions - I can work with it in any number format once the summary table is working?

    I do not know how to write VBA, I have been able to adjust others work once it is set up for me.
    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    1,814

    Re: Pull data based on date match

    VLOOKUP worked for me on your example worksbook...

    =IF(ISNA(VLOOKUP($B3,'Corn CBOT'!$A$3:$L$36,5,0)),"",VLOOKUP($B3,'Corn CBOT'!$A$3:$L$36,5,0))

  3. #3
    Registered User
    Join Date
    01-06-2012
    Location
    MN
    MS-Off Ver
    Excel 2013
    Posts
    62

    Re: Pull data based on date match

    Perfect! I was leaving out the ISNA from my vlookup attempts. I appreciate your help.

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,069

    Re: Pull data based on date match

    Since you are using 2010, you can use the IFERROR...

    =IFERROR(VLOOKUP($B3,'Corn CBOT'!$A$3:$L$36,5,0),"")
    HTH
    Regards, Jeff

  5. #5
    Registered User
    Join Date
    01-06-2012
    Location
    MN
    MS-Off Ver
    Excel 2013
    Posts
    62

    Red face Re: Pull data based on date match

    I will give that a try as well and really appreaciate the help. I could of messed around for a long time before I figured this out - if ever. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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