lookup
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. |
lookup
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. |
lookup
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. |
lookup
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. |
All times are GMT +1. The time now is 07:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com