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
|