Return value of another cell

tsammons · 04/01/22

Sheet 1 has the following two columns

Column 1(Yes/No); Column 2 (Date).

In sheet 2, looking for the following Formula:

If value in Column 1 = "Yes", return the corresponding date from Column 2

Any ideas?

Paul Newcome · 04/01/22

Try something like this...

=INDEX({Sheet 1 Column 2}, MATCH("Yes", {Sheet 1 Column 1}, 0))

tsammons · 04/01/22

Here is the formula I'm using:

=INDEX({Food Safety Weekly Training Range 15}, MATCH("Yes", {Food Safety Weekly Training Range 1}, 0))

This is returning an "Invalid Column Value" error.

Thanks for your help!

Paul Newcome · 04/01/22

Make sure both the column the formula is in as well as Range 15 are date type columns.

tsammons · 04/01/22

I didn't have the formula column set as a date . . worked like a charm. Thanks so much!

Paul Newcome · 04/01/22

Happy to help. 👍️

Formulas and Functions