Originally Posted by

On Wednesday, September 26, 2012 2:37:37 PM UTC-7, JamesTris wrote:[color=blue][i]

Hi again JamesTris,

After I sent my post I set about to try to set up a working sample sheet the best I could from your post. I got hopelessly lost on how the sheet should look and what needs to happen and where... etc.

I would be glad to look at an example worksheet and give it a shot if you want.
I'm at

Regards,
Howard

Originally Posted by Claus Busch

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