T Trevor Feb 16, 2008 #1 I want to display the result of where a row and column intersect from a table of values. Can anyone assist?
I want to display the result of where a row and column intersect from a table of values. Can anyone assist?
T T. Valko Feb 16, 2008 #3 See this screencap: http://img404.imageshack.us/img404/6895/lookupskx1.jpg
R RagDyer Feb 16, 2008 #4 Or ... with the *exact* scenario that Biff used, you can use XL's intersection operator (a space). Enter this in any cell: =Product3 South NOTE the <space> between the 2 arguments! To make this work, make sure that, from the Menu Bar: <Tools> <Options> <Calculation> tab, "Accept Labels In Formulas" *is* checked. =South Product3 also works!
Or ... with the *exact* scenario that Biff used, you can use XL's intersection operator (a space). Enter this in any cell: =Product3 South NOTE the <space> between the 2 arguments! To make this work, make sure that, from the Menu Bar: <Tools> <Options> <Calculation> tab, "Accept Labels In Formulas" *is* checked. =South Product3 also works!
