Stumped by a lookup scenario

[atomlin]

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

 

[RagDyer]

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!
==============================================

 

[TommySzalapski]

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