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


Sign In or Register to comment.