Data Lookup With 3 Criteria Number (Positive,Negative & Zero) Percentage

[muhammad susanto]

hi all..

i have a problem to data lookup with 3 criteria number (positive percentage number,negative percentage number,zero number)
for easy to understand maybe like below layout table :
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>

data	criteria	preference
Grade a	positive number	excellent
Grade a	negative number	worst
Grade a	zero number	equal
Grade b	positive number	good
Grade b	negative number	bad
Grade b	equal	equal
lookup/as target	as data (GIVEN)	expected result
Grade a	10% (random & as positive)	excellent
Grade a	0	?
Grade b	-27%	??

<tbody>
</tbody>

note :
all numbers (as criteria) are random

i hope someone would help me out..

cheers..

.sst

 

[muhammad susanto]

anybody would help me? How to solved it.

 

[AhoyNC]

Maybe something like this.
Note: I changed your Grade b, equal to Grade b. zero nunber.

Excel Workbook
	A	B	C
1	data	criteria	preference
2	Grade a	positive number	excellent
3	Grade a	negative number	worst
4	Grade a	zero number	equal
5	Grade b	positive number	good
6	Grade b	negative number	bad
7	Grade b	zero number	equal
8
9
10	Lookup/as target	as data (GIVEN)	expected result
11	Grade a	10%	excellent
12	Grade a	0	equal
13	Grade b	-27%	bad
Sheet

 

[bosco_yip]

Or, using Post #.03's layout table

In C11, copied down :

=TEXT(B11,IF(A11="Grade a","""excellent"";""worst"";""equal""","""good"";""bad"";""equal"""))

Regards
Bosco

 

[muhammad susanto]

thank you man!! Worked it...