Create a match formula

Copper Contributor

Hello everyone,


I'd like to create a formula (Index or match) to paste the date showing in the column if the column and row are matched with a ✔ sign in a new cell.


If someone can assist me, I'd really appreciate it, I attached a snippet for your reviewScreenshot 2024-04-03 113106.png.



1 Reply


With your permission, I recommend to provide more information.

You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.

I recommend: Always inform about your Excel version, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).

If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description.

Don't forget that not every Excel user has a clue about every job and what you see he can't see.

How I provide more Details.


Thank you for your understanding and patience