INDEX(COLLECT( )) where some rows are blank
I'm missing something here, but I'm not sure what. In this sheet I need to pull a date from a master sheet.
The formula works perfectly for the first two organizations, but then the next one it pulls is simply the next cell in the date column in the master that isn't blank. It isn't the date that goes with the third organization. When I tried without ISDATE and just put <>"" for the criteria, I got the same results.
You helped me figure out that I need a helper to pull the organizations in, which is working wonderfully (😀!), but there are no empty cells in the Organization column in the master sheet, though not all organizations in the master sheet are receiving funding. I don't know if this is a factor here. Do I need to refer to the Organization column perhaps?
In a nutshell, I need to pull the Date Funding Awarded from a column in the master sheet if it isn't blank. I need to match (do I need a nested MATCH?!) the organization with the date it received funding, both of which come from the master sheet.
Many thanks in advance for any insight you can provide.
Help Article Resources
Check out the Formula Handbook template!