On Wednesday, September 26, 2012 2:37:37 PM UTC-7, JamesTris wrote:
Hello,
I am really new to excel and playing around with a calculator of sorts.
What I am trying to do is autofill a specific cell (C2) of a calculator.
I made a separate table on the same sheet that has 6 columns, M2:R:30.
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.
=IF(VLOOKUP("x",R2:R30,1,)="x",M2:M30," ") I also tried using HLOOKUP
and failed.
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.
Thanks a lot and I hope what I wrote is not to confusing.
Just thought of an easier way to ask.
If I place an "x" in any cell of column R that would return the data in
the same row of column M to C2.
--
JamesTris
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