Hello Excel Gurus,

I would like to request your expertise with Excel formulas & functions. I have 2 worksheets (see below). In Sheet1, one project may have multiple funding sources and budget amounts. In Sheet2, I am trying to determine for each project the funding source with the highest budget amount. In Sheet2, Column C (Funding Source) illustrates the desired results.

I do not have experience with developing custom code (i.e. VBA) in Excel and would like to utilize the Excel formulas & functions to determine the desired results, if feasible.


Thank-you in advance for your timely response.


Sheet1
Sheet1.JPG


Sheet2
Sheet2.JPG