Greetings! I know the subject sounds easy, and if it is, then I am an idiot. I hope this is easy for someone, but it's driving me batty. I'm trying to figure out how to write a formula to insert the billing rate into column B based on the final 6 characters in column A. For example, since A2 ends in "L2-2TG", B2 should be $45. Since A3 ends in "L3-2TG", B3 should be $125. Nothing I've tried has worked. Any ideas, please and thank you?
| Billing Code | Annual Bill Rate/Radio | bill code ends with | rate | |
| X1000-L2-2TG | L2-2TG | $45 | ||
| X4000-L3-2TG | L2-3TG | $65 | ||
| X2000-L2-2TG | L2-4TG | $85 | ||
| X2000-L2-4TG | L3-2TG | $125 | ||
| X3000-L3-3TG | L3-3TG | $145 | ||
| X1000-L2-3TG |
