Hi Excel Forum Team,
Please see the example excel sheet for reference.
I need a formula that will reside in the Rate Percent ("H") column and will lookup and match the Project Number ("F") column and the Fund Number ("G") column with the information contained in the Table.
This formula will return the lowest Rate Percent, but however it will not count 0% as the lowest Rate Percent unless that is the only value available in the lookup.
Please let me know if I can answer any questions of further clarify the problem.
Thank you for your time and help.
Garrett
Bookmarks