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.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!