Vlookup in 2 fields on another worksheet

[Steve]

On Sheet1
I have a list of dates in column B and a list of numbers in column C.
I have data in all columns up to M.

In sheet2 I have todays date in A1: =today()
and a number in A2: 33

In sheet 2 I need a formula to lookup any row which matches todays
date in column AND matches the number in A2. I then need to display
all the row from column B:M.

Many thanks


STeve

 

[T. Valko]

I need a formula to lookup any row which matches todays date

Can there be more than 1 row that meets this condition?

Biff

 

[Steve]

Can there be more than 1 row that meets this condition?

Biff










- Show quoted text -

Yes. There is likly to be up to 15 that need to be displayed in a
predefined box on my second worksheet (probally 20 rows big).

Cheers

Steve

 

[T. Valko]

There's a couple of ways to do this.

The easiest way and the one that will impact performance of the file the
least is to use a filter. Add a column to the end of table and enter this
formula:

=IF(AND(A1=Sheet2!A$1,B1=Sheet2!A$2),"x","")

Copy down to the end of the table.

Then filter on that column using the "x" as the criteria. Then copy the
filtered list over to sheet 2.

That's the easiest way to do this but it isn't dynamic.

You could do this with formulas, but, depending on how much data needs to be
searched on sheet1 and how many records need to be pulled over to sheet2,
this can impact the performance of the file (slow things down).

How many rows of data are there on sheet1 that need to be searched? If it's
1000's then you will want to use the filter method. If you still want to
consider using the formula method let me know and I'll put together a small
sample file that demonstrates this and will put up a link to that file.

Biff