Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting the current month using a macro on a pivot table | Excel Discussion (Misc queries) | |||
Selecting a range of values on pivot table attribute with a macro | Excel Discussion (Misc queries) | |||
Selecting Specific Data within a Table | Excel Worksheet Functions | |||
Selecting multiple filters in a pivot table | Excel Discussion (Misc queries) | |||
Selecting valuse from a table | Excel Discussion (Misc queries) |