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.