Basically what I am wanting to do is on the "Summary" sheet have the user select a division (1-40) in cell P8 and the winning contractor for that division show up in cell Q8. In order to find the winning contractor, the formula in cell P8 needs to both:
1. Find the associated division as per cell P8 (which there can be multiple).
2. Find the contractor with the lowest bid amount within the cell P8.

I've tried countless times using formulas such as vlookup, index, match, sumproduct, and have had no luck. PLEASE HELP

Capture.PNG