Returning Text from Excel

[Closed]
Report
Posts
1
Registration date
Thursday December 12, 2013
Status
Member
Last seen
December 12, 2013
-
I have customer names located in Column B Rows 12-56; I have dates that they returned letters to me in column J rows 12-56.

My question is what is a formula i could use in another cell that would look through column J 12-56 and if the cell is blank return the text associated to that row in column B 12-56??


Thanks for any help in this!