About Us

Mazzaropi

Quote:

Originally Posted by SalientAnimal

Hi All.

I need to create a formula to evalute the value returned by the VLOOKUP. When the VLOOKUP makes a match if needs to check if the value of the returned value is:
Criteria 1
Between 06:00:00 and 06:30:00

Criteria 2
08:00:00 and 08:30:00

Criteria 3
09:00:00

Should the evaluated value fall between one of the specified value it needs to return a value of "Yes". If however the value falls outside the three mentioned criteria it needs to return a value of "No".

-----------------------------------------------------------------

Dear SalientAnimal, Good Afternoon.

I did an example for you.
Here it´s : DEC-13-2010-EXCELBANTER_VLOOKUP_With_Multiple_Criteria_HOURS.x ls
Take a look at this and tell me if it worked for you.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup multiple criteria multiple occurrences sum values	se7098	Excel Worksheet Functions	0	March 26th 09 07:31 PM
Vlookup with Multiple criteria and multiple sheets	Cinny	Excel Worksheet Functions	4	June 21st 07 01:47 AM
Vlookup for multiple criteria, multiple worksheets	jtoy	Excel Worksheet Functions	4	January 25th 07 09:26 PM
Vlookup with multiple criteria	nick	Excel Worksheet Functions	8	October 10th 05 03:46 PM
VlookUp with Multiple Criteria?	Arturo	Excel Worksheet Functions	3	December 20th 04 06:59 PM

Menu

About Us