# How do i structure a IF(AND with 2 lookups????

#### sleepdoc

##### New Member
Happy thanks giving Everyone!

Here ismy question.

I have a array. I need filter it twice (but not by using the autofilter)

The syntax of the construct I imagine will work is unknown to me, but hereis what I would like to accmplish

I want to say

If a date I pick from a drop down list matches a date in the array

the populate a new array with all the rows where the dates match.

Let me see if i can clarify further

I have an array where each row (not coulmn)is the details of a particular sale of an item

This massive list of sales rows has a column called the "sale date"

I want to go through every row (every sale) and make a new array of only the sales that occured on a particular date. So for example

(Row) (sale date) (sale amount) (id#)

1 11/23/05 \$5000 1
2 11/30/05 \$3000 2
3 11/23/05 \$2500 3
4 11/30/05 \$1000 4

OK. So now what I wish to do is populate a new array whch goes as follows.

The user first picks the Sale date. if he were to pick the4 sale date of 11/23/05, then he would ge a new array with 2 sales. ID# 1 and id#3 with all the details of that sale.

I hope someone can steer us in the right direction. It seemed so simple when I started, however, I have been unable to find the solution. The autofilter will clearly fileter for the date, but it is not in a new, seperate array where i need it. I'm trying to filter out from a master table of all sales, just the sales made on certain days and then just the sales on thoise days by certain sales people so that I can then print out for them the sales they have completed no a day by day basis.

Glenn

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying
You could filter the data, then copy the visible rows to another location. Do the whole thing by macro.

Replies
3
Views
508
Replies
5
Views
397
Replies
2
Views
208
Replies
0
Views
181
Replies
0
Views
204

1,217,500
Messages
6,137,008
Members
450,038
Latest member

### 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.

### Which adblocker are you using?

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

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