More on Intersection Lookups
Posted by Fizzy on March 22, 2001 2:37 AM
Gee this board is a real inspiration! Has got me to play around with other combinations (remember I am an Excel novice).
In addition to using:
have found that:
works as well (when you add a hidden row (2 in this example) and populate cells with 1,2,3,....
F3 and G3 are the lookup values
Vlookup and Hlookup combinations assume that the lookup values are in left-most cols and top-most rows however.
Using Mark's method (=aaa large)still can't see how I would enter lookup values in F3 and G3.
again thx for the inspiration ....