I need help with a look-up function for the table structure below. My look up function will be based on a value for the X axis, in this case lets call it 2. The Y axis will be 5. In this example, I need the formula to return the value .388. How do I accomplish this?
The table below is three columns wide with column headers 1,2,3, and 6 rows (Rows 1-6)
Column (X Axis) Search Value 2
Row (Y Axis) Search Value 5
1 2 3
1 0.010 0.022 0.023
2 0.110 0.120 0.130
3 0.095 0.299 0.423
4 0.114 0.361 0.511
5 0.123 0.388 0.548
6 0.130 0.413 0.583
The table below is three columns wide with column headers 1,2,3, and 6 rows (Rows 1-6)
Column (X Axis) Search Value 2
Row (Y Axis) Search Value 5
1 2 3
1 0.010 0.022 0.023
2 0.110 0.120 0.130
3 0.095 0.299 0.423
4 0.114 0.361 0.511
5 0.123 0.388 0.548
6 0.130 0.413 0.583