Sign in to join the conversation:
Hi ,
How to use Index and Match function in SS.Please advise with an example
=INDEX([Range of data to be displayed from], MATCH([Identifier to look for], [Where to look for the identifier], [sort option]), [column index optional])
Use the first portion of the INDEX formula to set where the data you want displayed is to come from. Use the MATCH in the second part of the INDEX formula to designate what row to pull the data from. If you have a unique identifier for each row, use that, the set where to look for the unique identifier. The third portion of the INDEX formula is optional. Use this to specify which column to pull the data from if the first portion of the INDEX formula covers multiple columns.
Here is a link for further explanation...
https://community.smartsheet.com/discussion/auto-filling-cell-based-entry-another-cell
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
