I have two tables above, in which minor_bay variable is common in both. I like to get a new table using a command that pulls out date variable (table1) rows that fall within two date range (in table 2) and have matching minor bay variables. Can anyone help to make a command using excel?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Joining two tables using multi-criteria (date range and matching col variable)
- Thread starter spaudel
- Start date
I have two tables above, in which minor_bay variable is common in both. I like to get a new table using a command that pulls out date variable (table1) rows that fall within two date range (in table 2) and have matching minor bay variables. Can anyone help to make a command using excel?
Excel Facts
Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Similar threads
- Question
- Question
