I have columns of mfg line, customer, month, weight, and forecast. The same
customer may have forecasts for multiple weights. I would like to be able to
setup a formula to return customer, weight, and forecast if it meets a
specified mfg line and month. My spreadsheet is 7000 rows long and I want to
compare data on a seperate sheet in the workbook.

For example:
Line Customer Weight Month Forecast
A Alpha 10 Mar 300
B Alpha 11 Jan 100
A Alpha 12 Mar 750
A Beta 10 Mar 200

The result for Mar and mfg line A would be:
Alpha 10 300
Beta 10 200
Alpha 12 750