Maybe =index(match())

Debra Dalgleish explains it he
http://www.contextures.com/xlFunctions03.html

Sweepea wrote:

For example:
Apple Orange Pear
A 1 4 7
B 2 5 8
C 3 6 9

How do I combine vlookup and hlookup to pick up the value in Row B and
Column Orange which will be 5?

Appreciate your help. Thank you.

--

Dave Peterson