I have column A with text: AAA,AA,A,BBB,BB ect. Each Text field has a value
ex. AAA=9, AA=8, A=7. I want to look in a column F which has assorted defined
text field (AAA, AA) and assign the proper value. Need to keep it simple.
I'm a beginner to Intermediate user.