Forum Discussion
help with lookup formula
Hello! I am on windows running excel 2016. I am trying to create a formula that helps me with a lookup from the first set of data to the second. I need to pull the automation name next to the send...
Patrick2788 Hello - thank you for this response! I applied this to my actual workbook but I am still returning incorrect results. Can you take a look t this notebook and see where I may be going wrong in applying your formula? thanks!
It looks like the NUM errors are coming from the fact a few of your dates in the 'send' sheet have date and time not just the date. The best solution is to fix the dates because we can't nest TRUNC in the COUNTIF for the range.
Patrick2788 I fixed those and that worked to correct NUM error - any idea on why I'm still returning the wrong "automation" name? TIA
- Ctrl+Shift+enter to calculate as an array.
- hmmm - I did that and nothing changed - suggestions...?