Forum Discussion
Solved
Microsoft Office Excel formula
See attached image. - Looking for formula that will look at column A and determine whether is is "E-Check" or just "Check". - Then depending on what it finds, it will place the value from column B ...
- Two ways to do it.
If you have SPILL capability:
=IF(A2:A8="E-Check",B2:B8,"")
Legacy Excel:
=IF(A2="E-Check",B2,"")
Two ways to do it.
If you have SPILL capability:
=IF(A2:A8="E-Check",B2:B8,"")
Legacy Excel:
=IF(A2="E-Check",B2,"")
If you have SPILL capability:
=IF(A2:A8="E-Check",B2:B8,"")
Legacy Excel:
=IF(A2="E-Check",B2,"")
- Excellent. Thank you and it does work.
Yok33
