Lookup data then fill mark "V" or "-" based on criteria

[muhammad susanto]

hello all...

how to get or lookup data then fill mark V or - with same criteria name and description
my target in cell H12 till J15 with dropdown list name in cell H10 as reference name
it's 3 criteria very good, good, bad.
here the layout

rumus rapot tk.xlsx
	G	H	I	J	K
1	Description	Names
2		Farah	Tika	Dyla
3	Mango	Very good	Good	Bad
4	Orange	Very good	Good	Bad
5	Banana	Good	Good	Bad
6	Grape	Bad	Bad	Very good
7	Papaya	Very good	Bad	Very good
8
9	Target/expected desired
10	Name ---->>	Farah
11	Description	Bad	Good	Very good
12	Mango	-	-	V
13	Orange	-	-	V
14	Banana	-	V	-
15	Grape	V	-	-
16	Papaya
Sheet1

for this case , please use excel 2010 or 2013 formula

any help greatly appreciated..

sst

 

[muhammad susanto]

yes...you're right, done!!

thank you again