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.

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.

The formula i am using is a one time effort,

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

--

Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"gvb132" wrote:

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.

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

"Satti Charvak" wrote:

The formula i am using is a one time effort,

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

--

Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"gvb132" wrote:

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.