# How to combine IFERROR VLOOKUP SUBSTITUTE Function Across Multiple Tables

1. ## 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

2. ## Re: How to combine IFERROR VLOOKUP SUBSTITUTE Function Across Multiple Tables

=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?

There are currently 1 users browsing this thread. (0 members and 1 guests)