Lookup Multi Tabel From Multi Sheets

[Kenshin]

Hi Ninjas glad see you again and i desperate need help from you guys

 

[Hui]

B4: =IF(MATCH($B$2,'1'!$A$4:$A$26,0)=1,$B$2,"")
B5: =IF(MATCH($B$2,'2'!$A$4:$A$26,0)=1,$B$2,"")
B6: =IF(MATCH($B$2,'3'!$A$4:$A$26,0)=1,$B$2,"")

 

[Kenshin]

Thanks Hui for the reply, it's just work for date that avalaible on 3 sheets, but how f the date is just available only on 1 sheet?

 

[Hui]

It will show the date on the sheet it is on, blanks on the others

 

[bosco_yip]

Maybe,

In "Result" Sheet B4, formula copied down :

=IFERROR(VLOOKUP(B$2,INDIRECT("'"&INDEX({1,2,3},AGGREGATE(15,6,1/(1/{1,2,3}*(COUNTIFS(INDIRECT("'"&{1,2,3}&"'!A4:A100"),$B$2)=1)),ROW(A1)))&"'!$A$4:$A$100"),1,0),"")

Regards
Bosco

 

[Kenshin]

Maybe,

In "Result" Sheet B4, formula copied down :

=IFERROR(VLOOKUP(B$2,INDIRECT("'"&INDEX({1,2,3},AGGREGATE(15,6,1/(1/{1,2,3}*(COUNTIFS(INDIRECT("'"&{1,2,3}&"'!A4:A100"),$B$2)=1)),ROW(A1)))&"'!$A$4:$A$100"),1,0),"")

Regards
Bosco

Awesome bro, the formula does the job, thank you man......thank you