Forum Discussion
DDTPS
Jun 12, 2023Copper Contributor
if equal formula
if value in E2 is = to value in B2, then transfer info in c2 to D2 How can I write that in a formula please.
DDTPS
Jun 13, 2023Copper Contributor
yes, when i do that I get a return that says FALSE.
what I am hoping to do is match the number in column B to the number in column E. if it does match - i would then need it to take the name in column D that is right next to the matched number in column E and put that name in column C(which is empty)
what I am hoping to do is match the number in column B to the number in column E. if it does match - i would then need it to take the name in column D that is right next to the matched number in column E and put that name in column C(which is empty)
Detlef_Lewin
Jun 13, 2023Silver Contributor
DDTPS wrote:
yes, when i do that I get a return that says FALSE.
what I am hoping to do is match the number in column B to the number in column E. if it does match
But there is NO match hence the FALSE.
- DDTPSJun 13, 2023Copper Contributorcorrect. Is there a formula that will work for what I am trying to do? I appreciate all of your help.