Oops! Except for some arcane Excel reason you can't use C or R as row
names. You could substitute _C and _R.

Alan Beban

Alan Beban wrote:
Highlight your table; click on Insert|Name|Create and select Top row and
Left column

Then =Orange B will return 5, =Pear C will return 9, etc.

Alan Beban

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.