View Single Post
  #2   Report Post  
RagDyer
 
Posts: n/a
Default

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