Trying to use Vlookup with multiple colums

Hello, I've been working on trying to pull filtered information from one sheet and have it autofill into a schedule.

My parameters are if Column R is <=today's date and column T is = 0 then return column B, C, D, L onto another sheet.

What does "one sheet", "another sheet" and a "schedule mean"?

So you want to capture a snapshot of certain columns on a particular day and save it to another sheet, like your Sheet1 copies.

You have posted in Excel General, suggesting that you want to use formulas, although depending on what you want you may need macros.

You want to capture date on or before a certain date. So each time you grab the data you will have more and more data. Is that what you had in mind?

There is probably a way to do this with formulas if you put the date of interest (rather than "today's date" on each sheet. Right now you just have text typed into a page header, rather than having an actual date appearing as data on the sheet. It could also be done with macros, using the date that the macro is run.

Hello Sandramv and Welcome to Excel Forum.
This is how an array entered formula* might be used to get the list of records meeting the conditions of "Column R is <=today's date [and not blank] and column T is = 0" (as shown on sheet 2).

Formula:

Please Login or Register  to view this content.

Note: Date is placed in cell A1.
*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.

You're Welcome, keep us apprised.