Need help with lookup

[Niecespieces1]

I need to look up a date on my assignment sheet, then look up column of same date on schedule sheet and return the value if it is not blank

See spreadsheet attached

Any help would be greatly appreciated.

[davesexcel]

Wow!
That is quit a workbook you have.
I took a chance of opening it and got overwhelmed.
Maybe make the workbook smaller and only show what reflects to your question.

[FDibbins]

Agree with Dave.

Finding the date column is easy....
=MATCH($O$2,'Schedule '!$1:$1,0) (column 103)

how do you determine which row to use?

[Niecespieces1]

I guess I did not word it correctly as far as what I am trying to accomplish.

I want to look at the date on the assignment sheet look for date on schedule and return values in that column on schedule of the same date 3:22