Index & Match with reference another sheet

Leslie Murray

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!

Leslie

Darren Mullen

Adding ",0" after the {Steering Committee Last Name1} in the Match Function would find only exact matches.

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

Darren Mullen

Adding ",0" after the {Steering Committee Last Name1} in the Match Function would find only exact matches.

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

Leslie Murray

Thank you!!