Excel Lookup
 

I want to display the result of where a row and column intersect from a table
of values.
Can anyone assist?

Excel Lookup
 

One way:

=INDEX(MyTable, row, column)


In article ,
Trevor wrote:

I want to display the result of where a row and column intersect from a table
of values.
Can anyone assist?

Excel Lookup
 

See this screencap:

http://img404.imageshack.us/img404/6895/lookupskx1.jpg

--
Biff
Microsoft Excel MVP


"Trevor" wrote in message
...
I want to display the result of where a row and column intersect from a
table
of values.
Can anyone assist?

Excel Lookup
 

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!


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"T. Valko" wrote in message
...
See this screencap:

http://img404.imageshack.us/img404/6895/lookupskx1.jpg

--
Biff
Microsoft Excel MVP


"Trevor" wrote in message
...
I want to display the result of where a row and column intersect from a
table
of values.
Can anyone assist?