Help with an Index/Match formula please

David G11
David G11 ✭✭
edited 06/07/23 in Formulas and Functions

Hi All,

Looking for some help with an Index/Match(if) formula please.

Basically, if the value of a cell in column 1 = the value of a cell in column 2, then return the corresponding value which is situated in column 3.

Please see attached screenshot for reference, I am working with dates across sheets.

if a cell in DATE ID = a cell in Date identifier THEN return the corresponding date which is appears in the Date column.

As always, thanks for the help.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!