I have this spreadsheet of insurance plans. Goal is to identify the cheapest plan given premium and expected annual medical expenditures.
10 columns, one column per plan
Row 2: Plan Name (in cells B2, C2, D2…). There is a text value in Row 2
Rows 3-29: Bunch of mathy stuff in formulas
Row 30: Total Cost (in cells B10, C10, D10…). This is also a formula.
Below this table I have a much smaller table which simply tells me the lowest cost plan of the 10, using a MINIMUM function. Let’s say this function is in A32. (Don’t know if that is necessary for this, but there it is.)
Currently, the function returns the correct value (lets say it’s in E30). But what it returns, of course, is the $ amount in cell E30. However… and this is the question… I also want to return the value in cell E2 (the plan name) as well.
Right now it’s telling me “Your cheapest plan is $3,043.14” (in cell E30).
I want it to “say”, “Your cheapest plan is $3,043.14, and it’s the BCBS-666SUX plan” (a value which can be found in cell E2).
So, effectively, I have an array in row 30 - I want to search that array to find the lowest value, returning the value found in an array in row 2, same column.
Uhhh… what else do y’all need to know? Did I even describe my problem correctly?
Thanks in advance!