Stumped by a lookup scenario

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>