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.