Stumped by a lookup scenario

A

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... :
 
R

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

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
 
Top