Microsoft Excel 010 - complete package

i am working on premiums and for premiums actuaries provide rates based on a combination of age and insurance tenor. i have a set of names with their ages and tenor on an excel sheet and i have the rate table, which is a two-dimensional table with the first row being the various tenors and the first column, ages. Typically i manually have to match each age with the tenor per customer to get the rate. But now i have like 600,000 excel lines to work with, there's no way i am getting the rates manually. i need help asap.

If I understand your post correctly, I think this is what you are looking for. With a table that looks like this in A1:D4, the formula shown below will use the values in E1 and F1 to find the intersection of those values and, in this case, return 2c

A B C D E F 1 1 2 3 2 c 2 a 1a 2a 3a 3 b 1b 2b 3b 4 c 1c 2c 3c=INDEX($B$2:$D$4,MATCH(F1,$A$2:$A$4,0),MATCH(E1,$B$1:$D$1,0))

The MATCH functions return the row_num and column_num arguments for the INDEX function.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History