Excel Lookup

T

Trevor

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

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!
 
Top