Index/Match Results Return only matching first entry on list

MegBLLC

I"m using Index match to return a contact based on the department entered in another cell. The department entries are copied from the drop down list in the other sheet so they should be exact matches. For some reason it's only returning a value for the first entry on the list, but the others give a "no match" error.

This is the formula I use: =INDEX({Department Contact List Range 1}, MATCH([Component or Support Department]@row, {Department Contact List Range 2}), 0)

screenshots attached below:

Paul Newcome

Move the second to last closing parenthesis to the very end.

You have:

), 0)

Try instead:

, 0))

Paul Newcome

Move the second to last closing parenthesis to the very end.

You have:

), 0)

Try instead:

, 0))

MegBLLC

That worked! How embarrassing! thank you!

Paul Newcome

Happy to help. 👍️