match value in cell to a value in a range

Q

Qaspec

I have a value (date) in D7 sheet2. I also have a range of dates in P1:p20
sheet1. In E7 if the date in D7 equals a date in the range on sheet1 I'd like
E7 to equal 1 if it does not I'd like it to equal zero. Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I assign "Apple" to a cell reference in this evaluate code? 2
Need Help with a VBA subroutine 0
copying a cell that has been formatted to cell with conditionals 3
Conditionl format for 1 cellthat looks at 3 cells. 9
loop to copy paste 5
Show value from one cell in another cell if today falls between a date range 5
One command in one cell initiating another command in another cel. 3
match multiple criteria ina range from multiple criteria multiplet 7

Top