Here is my function:
=LOOKUP(A18,'Week 1 Totals'!A18:A94,'Week 1 Totals'!J18:J94)
For some reason this is not working for me. I am trying to find a total number of hours worked for a given job. A18 is a job number. A18:A94 on week 1 totals sheet is a range where the job numbers are located for each job. J18:J94 on week 1 totals sheet is where the total hours are for each job. For some reason this function is returning 0 even though J18 = 1 where A18 on the current sheet matches A18 on the week 1 totals sheet. So it should return 1. I cant figure out why its not working. Any one know why.
Bookmarks