Vlookup across several sheets
 

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

Vlookup across several sheets
 

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)," ")

--
Biff
Microsoft Excel MVP


"Elton Law" wrote in message
...

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

Vlookup across several sheets
 

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.

"T. Valko" wrote:

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)," ")

--
Biff
Microsoft Excel MVP


"Elton Law" wrote in message
...

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

Vlookup across several sheets
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Elton Law" wrote in message
...
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.

"T. Valko" wrote:

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)," ")

--
Biff
Microsoft Excel MVP


"Elton Law" wrote in message
...

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