I am working on a project that needs to execute the sum of three related Rows (B2:B4), Then I need to ensure the sum is "greater than or equal to" a constant (B48). If so, I need to return the adjacent data in the row that contains the largest datapoint of the 3 row-range.
I used the formula below but I get #Value...so I included the IFERROR which only got rid of the error (obviously). Any ideas?
=IFERROR(IF(SUM(B2:B4>=$B$48),(VLOOKUP(MAX(B2:B4),A2:B4,1,FALSE))," ")," ")
Bookmarks