Quick background, ive ended up on this site multiple times while putting together excel sheets and figured its about time i join.
my current issue is trying to figure out a formula that would search in cell (e4) for any text, if text is found do nothing, if no text is found copy cell (b4) and paste into cell (l4). i will eventually be going down columns with this formula.
Thanks in advance
[TABLE="width: 500"]
b
[/td]c
[/td]d
[/td]e
[/td]Name
[/td]chk#
[/td]amount Due
[/td]amount paid
[/td]still owe
[/td]joe shmoe
[/td]$xxx,xxx
[/td]joe shmoe
[/td]jane doe
[/td]513
[/td]$xxx,xxx
[/td]$xxx,xxx
[/td]
[/TABLE]