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.
|