Report

Excel formula [Solved]

Ask a question Bonnie - Last answered on Jul 14, 2016 06:35PM
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.
See more 
Helpful
+1
moins plus
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!

Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!