'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

'if' formula selecting a cell from a table
 

Hi Aaron,

with your data, as in your example, in A1:D5 (including the headers):

=INDEX(B2:D5,MATCH(G2,A2:A5,0),MATCH(G1,B1:D1,0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Aaron Hodson (Coversure)" wrote in message ...
| 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
|

'if' formula selecting a cell from a table
 

Have you tried doing it with a Pivot Table?

http://peltiertech.com/Excel/Pivots/pivottables.htm

http://it.fuqua.duke.edu/public/2001...troduction.pdf

Hope this helps, at least a little,
Ryan---

--
RyGuy


"Niek Otten" wrote:

Hi Aaron,

with your data, as in your example, in A1:D5 (including the headers):

=INDEX(B2:D5,MATCH(G2,A2:A5,0),MATCH(G1,B1:D1,0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Aaron Hodson (Coversure)" wrote in message ...
| 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
|

'if' formula selecting a cell from a table
 

Thanks Ryan,

Doesn't help with this query, but a great tip I am looking at implimenting
in another spreadsheet,

Thanks

"ryguy7272" wrote in message
...
Have you tried doing it with a Pivot Table?

http://peltiertech.com/Excel/Pivots/pivottables.htm

http://it.fuqua.duke.edu/public/2001...troduction.pdf

Hope this helps, at least a little,
Ryan---

--
RyGuy


"Niek Otten" wrote:

Hi Aaron,

with your data, as in your example, in A1:D5 (including the headers):

=INDEX(B2:D5,MATCH(G2,A2:A5,0),MATCH(G1,B1:D1,0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Aaron Hodson (Coversure)" wrote in message
...
| 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
|