Multiple vlookups and IF statements

[GasConGuy]

Hello - I am building a table that I want to populate from another table, based on dates. On the first table, there are begin and end dates, job numbers, and a value. In my new table, there are job numbers in rows, and dates by day as columns. I want the formula to check if the date at the top of the column falls within the begin and end dates in the existing table, based on looking up the job number in my table. Make sense? So I have been using the below but it does not work correctly... any help is appreciated as always, thanks!

=IF(VLOOKUP(Sheet3!$A$4,' Update Nov Prelim'!$A$2:$I$60,2,0)>=Sheet3!C3,VLOOKUP(Sheet3!$A$4,' Update Nov Prelim'!$A$2:$I$60,7,0),IF(VLOOKUP(Sheet3!$A$4,' Update Nov Prelim'!$A$2:$I$60,3,0)<' Update Nov Prelim'!C2,""))

 

[leiarquel]

Can you try to send me a copy of your file? Thanks

 

[Fluff]

Can you post an example of both sheets?
If you follow the "Tools" link in my signature, you'll find some add-ins that will help you do that.