Vlookups with multiple criteria

Kmitchell

Active Member
Joined
Feb 27, 2007
Messages
353
Hi There,

Is there a way to use the Vlookup function to have it meet more than one criteria? For example if it's July and Department A then go to sheet 1, columns A:H. If it's May and Department B then go to sheet 1 columns I:T.

I have a lot of data originally on 15 tabs. But I've found a way to consolidate it into three buckets because there can only be 7 statements. I need a work around.

Any suggestions?
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Kmitchell

Active Member
Joined
Feb 27, 2007
Messages
353
I should also mention that month and departments are selected from a drop down list which are located on B1 and B2.
 

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
How mnay different ranges do you have? You gave A:H and I:T as examples, will all your ranges be different sizes like this? Will the VLOOKUP be the same except for the lookup ranges?
 

Kmitchell

Active Member
Joined
Feb 27, 2007
Messages
353
Yes. All the ranges (number of columns) will be the same. However, the columns used will be very large, all the way IV.
 

Forum statistics

Threads
1,181,658
Messages
5,931,269
Members
436,785
Latest member
KingGideon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top