View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aaron Hodson \(Coversure\) Aaron Hodson \(Coversure\) is offline
external usenet poster
 
Posts: 46
Default '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