Excel Lookup

[Trevor]

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

 

[JE McGimpsey]

One way:

=INDEX(MyTable, row, column)

 

[T. Valko]

See this screencap:

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

 

[RagDyer]

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!