Vlookup across several sheets

  • Thread starter Thread starter Elton Law
  • Start date Start date
E

Elton Law

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"?
 
So what's the lookup value/cell reference?

Where on the other sheets are we supposed to look for the lookup value?

See if this is what you had in mind. We'll assume the lookup table is
*exactly* structured and is in the *exact* same location on each sheet. The
lookup value will be cell A1 and the lookup table will be columns A:B
returning the result from column B.

=IF(OR(MIN(IM6:IO6)={1,2,3}),VLOOKUP(A1,CHOOSE(MIN(IM6:IO6),Daily!A:B,Weekly!A:B,Monthly!A:B),2,0),"")
 
Hi T. Valko,
I gave insufficient info, but you could still manage to solve it.
I've tried. Great JOB ...... Thanks for your help .... Tks indeed.
 
Back
Top