1.

Solve : Excel problem with pick a value from a table?

Answer»

I would LIKE to have the user pick a column heading value and enter it into a cell and pick a row heading value and enter it into a cell.

I would like Excel to pick the value at the intersection of the column and row and enter it in a third cell.

For example:
 
Choose a Letter      B                  
                        
Choose a Number      2                  
                        
Solution      ___                  
                        
                        
Table
      A      B      C      D
1      0.01      0.05      0.09      0.13
2      0.02      0.06      0.10      0.14
3      0.03      0.07      0.11      0.15
4      0.04      0.08      0.12      0.16

The solution cell should return the value 0.06

Does anyone know the solution to this problem? I have tried everything and the IF AND code is too LONG for the solution cell. There has to be a way. I've even spent hours at Borders looking through books to no avail.

Thanks MUCH!
--kmjMy hunch is this could be done with some VBA (Visual Basic for Applications) programming.  That's beyond my expertise.  You might post your question at http://www.excelforum.com/.How many rows and columns you have?
Consider a combination of IF + AND + LOOKUP.
I used to work on similar situation but I'll need sometimes to look for the workbook I did.This is BASED on your table, if it's just that simple.
But if you have unlimited number of rows and columns, you'll need to do some TWISTS and turns.



Discussion

No Comment Found