how to return 2 winner

this formula is correct...no problem.

=IF(IFERROR(SEARCH("F",VLOOKUP(C$8&$B10&"AKHIR",[keputusan_0.xlsx]KEPUTUSAN!$A$6:$Q$1000,8,0)),0)=1,"E",IF(IFERROR(SEARCH("F",VLOOKUP(C$8&$B10&"AKHIR",[keputusan_0.xlsx]KEPUTUSAN!$A$6:$Q$1000,10,0)),0)=1,"P",IF(IFERROR(SEARCH("F",VLOOKUP(C$8&$B10&"AKHIR",[keputusan_0.xlsx]KEPUTUSAN!$A$6:$Q$1000,12,0)),0)=1,"G",IF(IFERROR(SEARCH("F",VLOOKUP(C$8&$B10&"AKHIR",[keputusan_0.xlsx]KEPUTUSAN!$A$6:$Q$1000,14,0)),0)=1,"K4",IF(IFERROR(SEARCH("F",VLOOKUP(C$8&$B10&"AKHIR",[keputusan_0.xlsx]KEPUTUSAN!$A$6:$Q$1000,16,0)),0)=1,"K5","-")))))


the problem here

the formula only find and return 1 winner start from "F"

maybe in one event have 2 winner from same school, example

first winner "F100" (H10, workbook 2) return to cell C20, workbook 1 (this is ok)

second winner "F05" (N10, workbook 2) return to cell C21, workbook 1 ( how to return this value in C21)

** i had drag the formula into C21, it return "-"

so how

for your info:

workbook 1: KEJOHANAN OLAHRAGA MSSM 2012 SM

workbook 2: keputusan_0

problem will server... i upload later

admin

can delete this post....it has duplicated...sorry

admin

can delete this post....it has duplicated...sorry