Vlookup in 2 fields on another worksheet

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
I need a formula to lookup any row which matches todays date

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

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

Biff










- Show quoted text -
Click to expand...

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
 
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
 
Back
Top