Combination of Vlookup & Hlookup

Giganews Newsgroups
Subject: Combination of Vlookup & Hlookup
Posted by:  Sweepea
Date: Wed, 3 May 2006

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.

Replies