lookup

[gvb132]

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.

 

[T. Valko]

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)

 

[Satti Charvak]

The formula i am using is a one time effort,

=LOOKUP(A1,{"a","aa","aaa","b";7,8,9,10})

 

[gvb132]

I tried this and it failed to distinguish between "AA" and "AA-". The post
above your did work. Thank you for your help.
gvb132