title: How to reference a specific cell in a formula based on the contents of two other cells
body: <p>I'm trying to do a simple calculation where I multiply the contents of one cell by the contents of another. I have one table with 52 rows, and one with 9000. I want to multiply A value in the first table by a certain value in the second table based on two other values in the first table.</p>
  
  <p>The three values in the first table are N, Week, and Hour. The Rows in the second table are weeks 1-53 and the columns are hour 1-24. I want to create a formula that says "if Hour is 3 and Week is 2 in table 1, multiply Count by the value denoted by column 3 and row 2 in table 2." </p>
  
  <p>I've tried creating a named range with the Column headers being "Hour_1...Hour24" and the Row headers being "Week_1...Week_52". I then tried using the formula =Count*INDEX(Week_(A2),B2), where A2 is the week # in table 1 and B2 is the hour # in table 1. The main problem I'm encountering with this approach is that excel does not recognize Week_(A2) as a row. You would think that if A2=3, the system would recognize Week_(A2) as Week_3, but it doesn't. Any advice or ideas?</p>