btstamp50
asked on
Excel Vlookup based on two factors
Hi Experts. I have a table with three columns. Column J is number of years (1-20) and K (plan a) and L (plan b) contain various percentages.
I need a calculation that reads cell c4 (plan a or plan b as inputs) and c6. c4 is either the heading for column K (plan a) or the column L (plan b). c6 is a number of years (1-20). I need a look up value returned from this table with the calculation returned in cell d12.
I need a calculation that reads cell c4 (plan a or plan b as inputs) and c6. c4 is either the heading for column K (plan a) or the column L (plan b). c6 is a number of years (1-20). I need a look up value returned from this table with the calculation returned in cell d12.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER