Excel formula [Solved/Closed]

Report
-
 Blocked Profile -
Hello,

I am having trouble getting the right formula for:
Column O is equal to column N if Column C contains the text "Mastercard."
Nothing I've tried seems to work and it seemed so simple when I started out.
Any help would be appreciated.
Thank you.

1 reply


This satisfies your scope:



Whatever value is in cell C8, it will display in D8, as long as H8 contains the text "Mastercard"! Try using lower(H8)="mastercard".

Or you could actually, link the test word, to cell A1, as in:
=if(H8=lower(A1),C8)



Then what ever is in cell A1 will be the keyword to match for!~

Have FUN!

It's kind of fun to do the impossible! -Walter Elias Disney
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!