Trying to use Vlookup with multiple colums

[Sandramv]

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.

[protonLeah]

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

[Sandramv]

Nothing. i just like to save the previous schedule for a few days. Usually sheet 1 is Monday, Tuesday, sheet 2 Wednesday, Thursday, sheet 3 Friday, Saturday

[6StringJazzer]

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.

[Sandramv]

I thought about macros and will try that.

The project ready tab is the whole list of homes we have either in production or completed. I need to schedule crews each day, for 2 different trades, for the homes that are ready. The ready parameters are set by the "Ready to Stucco, "Stucco Finish," "Crew," and "Date Ready" I usually filter these out and begin to copy and paste it onto one of the sheets.

[JeteMc]

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

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.

[Sandramv]

Hello JeteMc,

Thank you. I'll try that out.

[JeteMc]

You're Welcome, keep us apprised.