how to find text values for a given grade?

**sumesh56** · 03-26-2013, 10:08 PM

I have a worksheet with slno(A1),names(B1),***(Male/Female)(C1).and some adjectives of persons in D1:H1.These adjectives are column headings of D:H. In col I ,i have to get the result of a formula(the two adjectives seperated by a comma)then in col J, i will award grade to the persons "A", "B" AND "C". When i award the grades in col J, any two adjectives should be printed in col I. in the adjoining cells of column I, there should appear other adjectives not the just used ones. it should continue till the list ends.what i mean to say is, the adjectives in column I, should differ row by row.
TASK-1
1.when i put "A", "B" OR "C" in J2,any two adjectives should appear in cell I2.
2.when i put "A", "B" OR "C" in J3,any two adjectives other than the just used ones should appear in cell I3.
3.when i put "A", "B" OR "C" in J4,any two adjectives other than the just used ones should appear in cell I4.
----------------------------
kindly see the attached "Find text vaues for grades_1.xlsx
-----------------------------------
TASK-2
------
Assumes that when i put "B" in cell J2 excel gives the adjectives (02 numbers seperated by a comma)in cell I2.
The second task requires excel to allot numerical values to the adjecties in the corresponding cells. The values are "A"=5, "B"=4 and "C"=3.
If i allot "A" in cell J2, and In cell I2 ,if excel gives two adjectives as polite and obedience, it should give 5 each in the corresponding cells (C2 and D2)
If i allot "B" in cell J2, and in cell I2, if excel gives two adjectives as liberal and intelligent, then it should show 4 each in the corresponding cells E2 and F2.
If i allot "c" in cell J2, and In cell I2 ,if excel gives two adjectives as obedience and consistent then it should give 3 each in the corresponding cells (D2 and H2)
----------------------
please see the attached "Find numerical values for text entered sample_2.xlsx.
thanks
---------------------------