Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup array
I am trying to lookup 'cell' C12 and dependant on what is in C12 give me a
grading of 1 - 6 from another table and place the answer in 'cell' P12. Lookup data is in 3 equal columns and return value data is in 1 column of the same length on the same worksheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup array
I guess that you want
= VLOOKUP(C12, lookup_columns,2,False) in P12 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "bessa_m5" wrote in message ... I am trying to lookup 'cell' C12 and dependant on what is in C12 give me a grading of 1 - 6 from another table and place the answer in 'cell' P12. Lookup data is in 3 equal columns and return value data is in 1 column of the same length on the same worksheet. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup array
Thanks but I don't know that I worded the question correctly as this hasn't
worked. If c12 = AAA I want a return value of 1 in P12, if C+ is in c12, I need 6 in P12. P12 can only be 1 - 6 but c12 can be from AAA... Aaa, right thru to Caa3 (it is selected from a drop down box). I think maybe I am not listing the look up data correctly in the table to begin with or I just can't do what i want. Sorry i am not that familiar with excel other than simple spreadsheets. Appreciate your thoughts. Thanks, Bess "Bob Phillips" wrote: I guess that you want = VLOOKUP(C12, lookup_columns,2,False) in P12 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "bessa_m5" wrote in message ... I am trying to lookup 'cell' C12 and dependant on what is in C12 give me a grading of 1 - 6 from another table and place the answer in 'cell' P12. Lookup data is in 3 equal columns and return value data is in 1 column of the same length on the same worksheet. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup array
List all the rules of assignment separately, then use it as a lookup
range. AAA AA A BBB BB B C+ C C- And in the cell in adjacent column have the 1 through 6 values in cells X1:Y9. Then use this formula in P12: =VLOOKUP(C12, $X$1:$Y$9, 2, False) On Dec 11, 9:47 pm, bessa_m5 wrote: Thanks but I don't know that I worded the question correctly as this hasn't worked. If c12 = AAA I want a return value of 1 in P12, if C+ is in c12, I need 6 in P12. P12 can only be 1 - 6 but c12 can be from AAA... Aaa, right thru to Caa3 (it is selected from a drop down box). I think maybe I am not listing the look up data correctly in the table to begin with or I just can't do what i want. Sorry i am not that familiar with excel other than simple spreadsheets. Appreciate your thoughts. Thanks, Bess "Bob Phillips" wrote: I guess that you want = VLOOKUP(C12, lookup_columns,2,False) in P12 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "bessa_m5" wrote in message ... I am trying to lookup 'cell' C12 and dependant on what is in C12 give me a grading of 1 - 6 from another table and place the answer in 'cell' P12. Lookup data is in 3 equal columns and return value data is in 1 column of the same length on the same worksheet.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with array lookup and max | Excel Worksheet Functions | |||
lookup array | New Users to Excel | |||
Lookup "greater than or equal to" in lookup array | New Users to Excel | |||
IF ARRAY LOOKUP ??? Help Please | Excel Worksheet Functions | |||
Lookup array? | Excel Worksheet Functions |