Excel 2007 : How to match dates on two worksheets to return value in populated cell

**colins** · 02-10-2010, 12:59 PM

Hi,

There are two worksheets and I need to search a range of dates on one sheet and return the value to the other if a cell in one is populated. Please see the example workbook attached. I attempted to use the IF statement and INDEX and MATCH, but cannot seem to get them to work together.

**NBVC** · 02-10-2010, 01:10 PM

Try:

=INDEX('Budget Daily'!$G$4:$HI$87,MATCH($C$3,'Budget Daily'!$B$4:$B$87,0),MATCH(Timesheet!$A8,'Budget Daily'!$G$4:$HI$4,0))

copied down.

**colins** · 02-10-2010, 01:25 PM

Wow, your answer was fast.

**colins** · 02-10-2010, 01:29 PM

That answer was very fast and nearly exactly what I needed. To finish this, how would I move the value over to the 'extra/vaction' column in the timesheet if a cell was populated on a saturday or sunday?

**NBVC** · 02-10-2010, 02:21 PM

Sorry.. was out on lunch...

Anyways, if all you will enter is 1's and 0's then perhaps we can change formulas to:

in N8:

Please Login or Register  to view this content.

and in O8:

Please Login or Register  to view this content.

both copied down

**colins** · 02-10-2010, 03:12 PM

1's and 0's might work, but several other things will need to change if they are used. Is it possible to not display '0' and simply leave the cell blank if not populated?

**NBVC** · 02-10-2010, 03:19 PM

Try:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

**colins** · 02-10-2010, 05:19 PM

That worked perfectly! Thanks so so much for the assistance!!!

**NBVC** · 02-10-2010, 05:34 PM

You are welcome,

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save