I want to find out how much life insurance a person can get based on tobacco usage, their age and their budget. I have life insurance rate sheets that have tobacco/age/rate/death benefit -- where the rate and death benefit increases from $30,000 death benefit to $250,000 and the premium goes up. A 40 year old with $50 to spend would have a different death benefit than a 40 year old with $100 to spend. I have both excel sheets. I just don't know how to get them to look up across multiple rows.
Solved by V. S. in 22 mins