Report

Excel formula [Solved]

Ask a question Bonnie - Latest answer 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

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!