media_karen
New Member
- Joined
- Mar 2, 2017
- Messages
- 1
Hi all,
The titles says it all. I would like to get a sum value via lookup based on if the text thread matches my search criteria. Below is an example of what I would like to do!
<tbody>
</tbody>
<tbody>
</tbody>
I would like my formula to search though column A on the first able and find all text strings with the words "MOB" & "INAPP" in them. Then it would pull the values corresponding to that string and sum it up. Currently, I have a formula that works with one keyword. But with more variations of the string, I need at least two keywords to make it work. Is that even possible?
Thanks in advance!
The titles says it all. I would like to get a sum value via lookup based on if the text thread matches my search criteria. Below is an example of what I would like to do!
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Mobile | Spend |
MOB INAPP | $300.00 |
MOB MW | $250.00 |
<tbody>
</tbody>
I would like my formula to search though column A on the first able and find all text strings with the words "MOB" & "INAPP" in them. Then it would pull the values corresponding to that string and sum it up. Currently, I have a formula that works with one keyword. But with more variations of the string, I need at least two keywords to make it work. Is that even possible?
Thanks in advance!