Index & Match with reference another sheet

Hi there -

I'm trying to use Index, Match as I've seen in this community to bring in fields based on matching the last name. For the most part it works, excepted when there isn't an exact match ... Is there a way to say only exact matches?

Sheet 1 has many columns including Last Name & this formula to get the Committee Decision:

=INDEX({Committee Decisions}, MATCH([Last Name]@row, {Steering Committee Last Name1}))

{Committee Decisions}, = just the column with Committee Decision from sheet 2

{Steering Committee Last Name1}= just the column with last name from Sheet 2

Sheet 2 has columns for Last Name, Committee Decision, Award Amount, etc

Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!