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...
=BYROW(B4:B9,LAMBDA(row,IF(OR(ISNUMBER(SEARCH($G$4:$G$6,row))),"Medical","")))With LAMBDA and helper function BYROW you can try this formula.