lookup

  • Thread starter Thread starter gvb132
  • Start date Start date
G

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.
 
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)
 
The formula i am using is a one time effort,

=LOOKUP(A1,{"a","aa","aaa","b";7,8,9,10})
 
I tried this and it failed to distinguish between "AA" and "AA-". The post
above your did work. Thank you for your help.
gvb132
 
Back
Top