get value of the cell below

**janjan_376** · 12-21-2009, 01:20 PM

Hi. Please help me on this one:

If A1 contains the word "store" I would like to have F2 to have the value of B1 and the Value below B1 (which is B2) concatenated. Please help. Thank you.

**JBeaucaire** · 12-21-2009, 01:27 PM

How about:

=IF(A1="store", B1&" "&B2, "")

**scaffdog845** · 12-21-2009, 01:59 PM

Or using If and CONCATENATE

Please Login or Register  to view this content.

**JBeaucaire** · 12-21-2009, 03:28 PM

Scaffdog, my option does use IF and concatenation without the need to put CONCATENATE in the formula, not required any longer since the & operator does the whole job now.

**janjan_376** · 12-21-2009, 03:57 PM

Thanks a lot.

**JBeaucaire** · 12-21-2009, 04:33 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)