No Match error with Index Match

User251

Hi,

I have a column in sheet A that uses the Index Match function to collect data from different sheets. The formula worked perfectly with two source sheets, but I keep getting the #No Match error when referencing one specific sheet, despite double-checking the search value to ensure it matches exactly what I have in Sheet A.

Initially, I thought the issue might stem from using a calculated value/column in the source sheet. However, even when I switch to a column with regular data, I still get the No Match error.

Do you have any ideas on why this is happening?

Paul Newcome

Are you able to provide some screenshots and the formula(s) you are using?

User251

Thank you so much @Paul Newcome. You request helped me identify the issue. While preparing the screenshots to send to you, I realized that I included a '0' for the [search_type] argument in the MATCH function, which correctly pulled the data. However, I omitted this in the second formula, leading to the error.

Thanks again!

User251

any suggestions?

Paul Newcome

Are you able to provide some screenshots and the formula(s) you are using?

User251

Thank you so much @Paul Newcome. You request helped me identify the issue. While preparing the screenshots to send to you, I realized that I included a '0' for the [search_type] argument in the MATCH function, which correctly pulled the data. However, I omitted this in the second formula, leading to the error.

Thanks again!