'if' formula selecting a cell from a table
Well, it is to me.
I am trying to create a rating matrix within excel, that can produce rates
from a table.
I have been searching through the forums for a while and cannot trace
anything that will assist me.
I have a table with 4 rows and 3 columns. the columns (for agruements sake)
are named A,B,C and the rows are WXVY.
I want a formula that will work to select a cell from the table depending on
the user inputting A, B or C into (G1) and W,X,Y or Z into (G2) - this one
then produce the desired premium into (H1)
Does this make sense? I hope someone can help me.
Thanks
Aaron
|