Hello,
This has been racking my brain and my original formulas are pulling in the wrong values. Here is what I'd like to do...
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
This has been racking my brain and my original formulas are pulling in the wrong values. Here is what I'd like to do...
- I have two Excel Tables; Table 1 where all my data exists. I would like to have a formula to determine if CATEGORY = A then I want to check if any LOOKUP words ( WHOLE WORDS ONLY) are found in the teh description--if so, return Table 2's SUB-CAT
- If not, just return "888".
- I need to lookup whole words so that in the example of "GI Joe", Sub-cat returns "789" because it found GI vs. "456" and ignoring "G"
Table 1
DESCRIPTION | CATEGORY | SUB-CAT |
GI Joe | A | 789 |
I Love Coffee | A | Should return error to indicate no words found in description is found in Table 2 Lookup Words (this will alert me to add in the future) |
pizza is great | A | 000 |
Help Me! | C | 888 |
<tbody>
</tbody>
Table 2
LOOKUP Words | SUB CAT |
Basketball | 123 |
G | 456 |
GI | 789 |
PIZZA | 000 |
<tbody>
</tbody>