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>
[TABLE="class: tableizer-table"]
<tbody>[TR="class: tableizer-firstrow"]
[TH]data[/TH]
[TH]criteria[/TH]
[TH]preference[/TH]
[/TR]
[TR]
[TD]Grade a[/TD]
[TD]positive number[/TD]
[TD]excellent[/TD]
[/TR]
[TR]
[TD]Grade a[/TD]
[TD]negative number[/TD]
[TD]worst[/TD]
[/TR]
[TR]
[TD]Grade a[/TD]
[TD]zero number[/TD]
[TD]equal[/TD]
[/TR]
[TR]
[TD]Grade b[/TD]
[TD]positive number[/TD]
[TD]good[/TD]
[/TR]
[TR]
[TD]Grade b[/TD]
[TD]negative number[/TD]
[TD]bad[/TD]
[/TR]
[TR]
[TD]Grade b[/TD]
[TD]equal[/TD]
[TD]equal[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]lookup/as target[/TD]
[TD]as data (GIVEN)[/TD]
[TD]expected result[/TD]
[/TR]
[TR]
[TD]Grade a[/TD]
[TD]10% (random & as positive)[/TD]
[TD]excellent[/TD]
[/TR]
[TR]
[TD]Grade a[/TD]
[TD]0
[/TD]
[TD]?
[/TD]
[/TR]
[TR]
[TD]Grade b[/TD]
[TD]-27%[/TD]
[TD]??
[/TD]
[/TR]
</tbody>[/TABLE]

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...