Help with a formula.

[devinberry1997]

I'm looking for a formula that will take the Sq Ft totals from AQ37-AQ61 on the "Harvest By Blend" tab of this sheet and auto populate it in G11-G380 on the "Turf Summary" tab of this sheet. It needs to populate correctly based on the Date (C-column), Field # (E-column), & the Blend (F-column). Any help is appreciated!

Here is a copy of the sheet with no sensitive information:

Report Sheet Master-24 (Mr. Excel).xls

RI Cut Sheet Cut Date, ,Wednesday,Maine Farm,Total Sq. Ft. Ship Date,Daily Cut Sheet,2000 Dean,Dean, Sq Ft,Dean,Blend,Field,Pal,Dean,Sizes,T-R,Dean,Customer,Location Doug,1,Trip#,1,500,Blue,510A,1 ttf,1137,Driver,2,500,BSC,510A,1 153,Truck,3,500,BOS,510A,1 258,Air,4,500,Penn3,552A,1 D,Field#s...

docs.google.com

 

[Rijnsent]

You're probably looking for a VLOOKUP or XLOOKUP formula.
Something like

=VLOOKUP(E11&" "&F11,AP37:AQ61,2,FALSE) or v=VLOOKUP(E11&" "&F11,AP37:AP61,AQ37:AQ61) (both untested)

Read more: XLOOKUP Function