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
Hello I could use some help with this one. I got the formula to work in the "number column"…. but I cant currently get it to work as a column formula. Basically what I am trying to achieve is have it add a number in order if the "footer comp" column is unchecked. and miss is unchecked Right now it is counting but in the…
I'm need to apply a function to average a column (answer is correct (8)) if the other column (The nurse is caring for a a patient who dove into a) is NOT blank. I copied this over from an excel spreadsheet. I would like to keep the average in the top row. Right now it's saying "#unparseable" as the formula is not the same…
This discussion was created from comments split from: How do I combine multiple INDEX Collect formulas in one Formular?.
