Forum Discussion
HELP!! Stuck on INDEX/MATCH/IF Formula for Days!
Hi there! I've been trying to create a some-what dynamic Excel worksheet for my monthly expenses, so I can analyze data in real time. Just a small intro-- I have data imported from my bank s...
=IF(OR(ISNUMBER(SEARCH($G$4:$G$6,B4))),"Medical","")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
I added this picture as a reference to my reply. Sorry, I'm new to the community! Trying to figure out the system (:
