Formula to Mark a Cell and Place a Corresponding Value in another Cell

[OZEXCEL]

Hello,

I am new to Excel, so this may be a basic question. I have two Columns:

A B
1
2
3
4
5

I would like to create a formula in one cell (E2) such that if I place an "x" (or a number perhaps) in a cell in column B, the corresponding value in Column A will appear in cell E2. For example, if I place an x in B3, a "3" (from A3) would appear in E2. If I placed an "x" in E4, a "4" would appear in E2, instead.

Please help!

Thank you,

Oz

 

[Dantrith]

Misread question, let me put a little more thought into it.

maybe try putting
=IF(B1>1,A1,0)
into cell E2, I think that does what you want. As long as the value in B is greater than 0.

 

[bbott]

If you want it to populate column E if anything is in column B, try:

=IF(B1<>"",A1,"")

 

[Chris Macro]

=SUMIF(B1:B5,"x",A1:A5)

 

[OZEXCEL]

Thank you all!

Looks like the =SUMIF(B1:B5,"x",A1:A5) worked so that it covered the entire range! Thank you, Chris!

bbot, The =IF(B1<>"",A1,"") worked too, but only for one cell at a time. I wanted it to only apply to one cell (E2) not the entire E column. For example, if I place an x in B2, then cell E2 will show a 2. If I place the x in B4, then cell E2 will show a 4. Basically, I wanted it to apply to the range of A and B, but only in one cell (E2). I don't think my question was that clear> sorry about that. But thank you for your help.