Stumped by a lookup scenario
 

I'm trying to LOOKUP value #1 in one cell, then LOOKUP value #2 in a
second cell. Based on the result of those 2 LOOKUP's, I want the
furmola to return the correct value from the intersection of the
LOOKUP results in a table of data. I'm stumped...is this possible?
Thanks in advance... :D

Data list = A1 to E25

Value to find in Column A is entered in F1
Value to find in Row1 is entered in F2

=INDEX(A1:E25,MATCH(F1,A1:A25,0),MATCH(F2,A1:E1,0) )
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"atomlin" wrote in message
...
I'm trying to LOOKUP value #1 in one cell, then LOOKUP value #2 in a
second cell. Based on the result of those 2 LOOKUP's, I want the
furmola to return the correct value from the intersection of the
LOOKUP results in a table of data. I'm stumped...is this possible?
Thanks in advance... :D

It is hard to tell exactly what you are trying to do. Check out the
Indirect, HLookup, and VLookup functions. If these don't do what you
want, repost and be a little more specific.

Szalapski


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=395511