Index and Match

I am trying to use Index and Match in place of Vlookup and I find that when I am trying to update the reference all index and match formula's get updated to the most updated reference.

Example: I am trying to pick up start and end date for one record. When I index and match reference to start, the end date also becomes the start date. Kindly advise.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!