You should create a 2 column table like this:

...........J..........K
1.....AAA......9
2.....AA.........8
3.....A............7
4.....BBB.......6
5.....BB.........5

Then use a lookup formula like this:

F1 = lookup value = BBB

=VLOOKUP(F1,J$1:K$5,2,0)

--
Biff
Microsoft Excel MVP


"gvb132" wrote in message
...
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.