# Pull data based on date match

1. ## 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!

2. ## 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. ## Re: Pull data based on date match

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

4. ## 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),"")

5. ## 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.

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