Hi. I'm attaching my workbook. Column A has dates and blanks. Column B has numbers (1 or 2). Column C has dates. I will make an example so you understand faster my problem.
So, C4 is 3/8/2007. I want to find the row that in column A has 3/8/2007. Here it is row 397. If B397 is 1 I want 1 in D4. If it's 2 I want to have 0 in D4.
Hope you understand what I'm trying to do!
Thanks for any help!
Hi,
Try
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Here's another one...
=IF(VLOOKUP(C4,A:B,2,0)=1,1,0)
Or...
=--(VLOOKUP(C4,A:B,2,0)=1)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you both! Both work!
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks