Find a single value from tables by selecting two variable inputs?
in [Functions]
|
Prev: Counting Number of Discrepancies between 2 rows
Next: emailing from excel 2003 thru outlook 2007 is not being recieved
From: jj023 on 16 Feb 2010 09:15 I am trying to have a worksheet locate a single data value based on two, variable input values. The single data value is located at the intersection of two variables in tables within the workbook. LOOKUP functions are only good for one variable and column/row identifier. Since I have two variable inputs, this won't work. Any ideas would be extremely helpful. Thanks.
From: Mike H on 16 Feb 2010 09:41
Hi, A general formula for a table lookup would be this =INDEX(A1:E20, MATCH(F1,A1:A20,0), MATCH(G1,A1:E1,0)) Where A1:E20 is the entire table including row and column headers F1 is the value to match in the column G1 is the value to match in the row The intersect of the 2 is returned -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "jj023" wrote: > I am trying to have a worksheet locate a single data value based on two, > variable input values. The single data value is located at the intersection > of two variables in tables within the workbook. LOOKUP functions are only > good for one variable and column/row identifier. Since I have two variable > inputs, this won't work. Any ideas would be extremely helpful. Thanks. |