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