Forum Discussion
Return value based off of earliest Date and Criteria
Hello, I realize there may be a similar question out there but had trouble finding exactly what I was looking for so I hope someone here can help! I am looking to return the earliest stage b...
Place this formula in F2:
=VLOOKUP(E2&C2,CHOOSE({1,2},$B$2:$B$13&$C$2:$C$13,$D$2:$D$13),2,0)
Hi Patrick2788 - thanks for your help! This unfortunately did not work for me. I am getting N/As and only Customer Closed Won. I just made sure that the date formats match as well. Please see below
What does your formula look like?
