Vlookup Problem

[muhammad susanto]

hi all....

how to fix lookup problem this below table :

AS CLUE :
B as representative GOOD
LOOKUP :	RR-------------ENOUGH
RB-------------BAD
expected result
GOOD
ENOUGH
BAD

<tbody>
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] seq # [/TD]
[TD="align: center"] B [/TD]
[TD="align: center"] RR [/TD]
[TD="align: center"] RB [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] 1 [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] 1 [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] 2 [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] 1 [/TD]
[TD="align: right"] - [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] 3 [/TD]
[TD="align: right"] 1 [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] 4 [/TD]
[TD="align: right"] 1 [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] 5 [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] 1 [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 2 [/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]given[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: left"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] V [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: left"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

any help much appreciated...
m.susanto

 

[sheetspread]

This?

Excel 2010
	A	B	C	D
1	seq #	B	RR	RB
2	1			1
3	2		1
4	3	1
5	4	1
6	5			1
7
8
9	2
10	RR
Sheet2

Cell Formulas
Range	Formula
A10	{=INDEX($B$1:$D$1,MATCH(1,INDEX(TRANSPOSE($B$2:$D$6),,A9),0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[muhammad susanto]

hi...like my sample/expected result...how to adding mark "v"

 

[sheetspread]

Like:

Excel 2010
	A	B	C	D
1	seq #	B	RR	RB
2	1			1
3	2		1
4	3	1
5	4	1
6	5			1
7
8
9	2
10
11		Good
12	V	Enough
13		Bad
Sheet2

Cell Formulas
Range	Formula
A11	{=IF(MATCH(1,INDEX(TRANSPOSE($B$2:$D$6),,$A$9),0)=ROW(A1),"V","")}
Press CTRL+SHIFT+ENTER to enter array formulas.

?

 

[jtakw]

Cross posted here: https://www.excelforum.com/excel-fo...ake-mark-v-using-lookup-data.html#post4942874

 

[Aladin Akyurek]

​

Cross posted here: https://www.excelforum.com/excel-fo...ake-mark-v-using-lookup-data.html#post4942874

@ muhammad susanto
​

You don't have to carry different identities as the above link seems to show in order to get help...​

hi all....

how to fix lookup problem this below table :

AS CLUE :
B as representative GOOD
LOOKUP :	RR-------------ENOUGH
RB-------------BAD
expected result
GOOD
ENOUGH
BAD

<tbody>
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] seq # [/TD]
[TD="align: center"] B [/TD]
[TD="align: center"] RR [/TD]
[TD="align: center"] RB [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] 1 [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] 1 [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] 2 [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] 1 [/TD]
[TD="align: right"] - [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] 3 [/TD]
[TD="align: right"] 1 [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] 4 [/TD]
[TD="align: right"] 1 [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"] 5 [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] 1 [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] 2 [/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]given[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: left"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"] V [/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: left"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

any help much appreciated...
m.susanto

In C14 just enter and copy down:

=IF($D14=IFERROR(VLOOKUP(INDEX($G$2:$I$2,MATCH(1,INDEX($G$3:$I$7,MATCH(D11,$F$3:$F$7,0),0),0)),{"B","GOOD";"RR","ENOUGH";"RB","BAD"},2,0),""),"V","")

 

[Macropod]

@ m.susanto
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html