# How to show value in row A in column A if column B row A value is TRUE

If column B row A value is "7" and column A row a is John, I'd like the result to show "John 7" in a another cell.
###### Who is Participating?

x

Commented:
I'm not entirely sure this is what you want, but perhaps

=IF(B1=7, A1&" "&B1)

and copy down as needed.
0

Author Commented:
Rorya,
Thanks, I'll give that a try.

I made a change..what if I want to check if the number is greater than 0 and THEN A1&" "&B1 as you had suggested?

Thank you.
0

Commented:
=IF(B1>0, A1&" "&B1)
0

Older than dirtCommented:
Is this what you want?

=IF(B1>0, A1&" "&B1)

I ask because when the value in column B is zero, the "another cell" value becomes "FALSE". If you'd rather it be blank then do this instead

=IF(B1>0,A1&" "&B1,"")

And of course in either case copy down as needed,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.