Excel formula
Solved/Closed
Related:
- What is the formula of cell c8
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Excel formula for color of cell - Guide
- Excel marksheet formula - Guide
1 response
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

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