Lookup array

[bessa_m5]

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.

 

[Bob Phillips]

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]

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

 

[iliace]

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)