I don’t want to go too far into this project before getting my fundamental problem fixed.
| CC | Team |
|---|---|
| 120/7C/ME | Cargo Chargers |
| 120/8A/ME | Cargo Chargers |
| 120/7C/F2 | We’re Working It |
| 120/8C/F | Top Dogs |
| 123/9B/MI | The Wizards |
When I put in =LOOKUP(120/7C/ME,A2:A6,B2:B6)
I get We’re Working It when I should be getting Cargo Chargers. If I do this with simple 1,2,3 A,B,C it comes out correctly every time.