Hi James,

Am Wed, 26 Sep 2012 21:37:37 +0000 schrieb JamesTris:

I thought that if I could place an "x" in any cell of R2:30, I could
have a forumla look for the x and then autofill C2 with data from the
cooresponding row. So for example place "x" in R2 and the data from M2
gets populated in C2. This is what I have so far. The problem I have is
that it works by only putting the data from M2 into C2, no matter where
I place the "x" in R.

I have 4 separate cells that I would like to do this for, C2 cooresponds
to the data in M2:M30, D2 for N2:N30, C3 for O2:030, and D3 for P2:P30.
Once I get the initial formula correct I should be able to progress.

in C2 try:
=INDEX(M2:M30,MATCH("x",$R$2:$R$30,0))
in D2:
=INDEX(N2:N30,MATCH("x",$R$2:$R$30,0))
and so on


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2