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
Bookmarks