| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select cell from range based on input in excel xp
Thanks Ron,
That did what I need. Gary "Ron Coderre" wrote: Try this: Using: your_grid_range in B1:W20 A1: (Word from the first row of the range) A2: (Word from first column of the range) A3: INDEX(B1:W20,MATCH(A2,B1:B20,0),MATCH(A1,B1:W1,0)) That formula starts with B1:W20 and returns the value at the intersection of the column that contains the word in A1 and the row that contains the word in A2. Does that help? *********** Regards, Ron "dingy101" wrote: I have a worksheet with a table of data in it. Based on user input generated from a pull down box that lists the values in the first column and another pulldown that lists the values in the first row of the table, how do I get the value of the field that is in the field where the row and column intersect? I want to read this value and use it in other formulas. Office XP Gary |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How to select a range whose name is entered in a cell. | Excel Worksheet Functions | |||
| Apply cell shading based on adjacent cells in EXCEL | Excel Worksheet Functions | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
