Part 1 - How can I get the value from the cell at an intersection of a row and a column. I want it to be based on the row heading and column heading (so it's dynamic) and not based on the actual column or row (A, B, 1, 2, etc.)
Name Age Sex Marital Status Value1 Value2
Bob 23 M Single 5 15
Joe 42 M Married 4 8
Jill 26 F Divorced 7 23
Steve 19 M Single 2 34
If on another sheet I want to get the value from Row "Steve" and Column "Marital Status" to get "Single", how do I do this:
Steve FORMULA TO RETURN "Single"
I want it to be dynamically based on both the row and column, so if I change Steve to Jill, the formula's results change to "Divorced".
Part 2 - Is there a way to do the same thing as above, but summing the last two columns (Value1 and Value2) without having to do the solution from above twice (adding the two results together).
Steve FORMULA TO RETURN 36
Hope this all makes sense.