Excel formula

Solved/Closed
Bonnie - Jul 14, 2016 at 04:22 PM
 Blocked Profile - Jul 14, 2016 at 06:35 PM
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 response

Blocked Profile
Jul 14, 2016 at 06:35 PM
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