Dear expert,
Got 2 questions.

1. How is the command for vlookup if I want to search something that need to
search across 3 sheets please?
To be precise, I have 4 sheets "Run", "Daily", "Weekly" and "Monthly" in a
file.
Command will be in sheet "Run" and vlookup something that may be in sheets
"Daily", "Weekly" and "Monthly".

2. Say a cell IP6 in Sheet "Run" ... have a command like this.
=IF(IL6="","",IF(MIN(IM6:IO6)=1,"Daily",IF(MIN(IM6 :IO6)=2,"Weekly",IF(MIN(IM6:IO6)=3,"Monthly",""))) )
The outcome in IP6 can be either "Daily" or "Weekly" or "Monthly" ... depend
on the min value of cell IM6:IO6.
If IP6 is "Daily", can I set a vlookup command based on the outcome in IP6
and search same-named sheet please ?
For instance .....
If IP6 answer is "Daily", can I set the vlookup command in cell IQ6 and
search from Sheet "Daily" automatically?
If IP6 answer is "Weekly", can I set the vlookup command in cell IQ6 and
search from Sheet "Weekly"?
If IP6 answer is "Monthly", can I set the vlookup command in cell IQ6 and
search from Sheet "Monthly"?