How to combine IFERROR VLOOKUP SUBSTITUTE Function Across Multiple Tables

Hi all,

I have formula for IFERROR and multiple sheets name DailyWatchlist and WeeklyWatchlist just like below:

=IFERROR(VLOOKUP(SUBSTITUTE(A5,"*","~*"),DailyWatchlist!$A$2:$F$2000,6,FALSE),"")
=IFERROR(VLOOKUP(SUBSTITUTE(A5,"*","~*"),WeeklyWatchlist!$A$2:$F$2000,6,FALSE),"")

How to combine above sheets like formula below but still using IFERROR VLOOKUP and SUBSTITUTE?

=IF(A1=1,VLOOKUP(B1,Table1,2,FALSE),IF(A1=2,VLOOKUP(B1,Table2,2,FALSE),""))

Hopefully somebody can help me.

Thanks

Already found solutions

=IFERROR(VLOOKUP(SUBSTITUTE(A5,"*","~*"),DailyWatchlist!$A$2:$F$2000,6,FALSE),IFERROR(VLOOKUP(SUBSTITUTE(A5,"*","~*"),WeeklyWatchlist!$A$2:$F$2000,6,FALSE),""))

Thanks everyone..How to put solved on this thread?