when nothing from Index/match

hana.lee73416

Hello,

when there is no return from index/match, instead of marking it N/A, it randomly picks any value which making the match incorrectly.

any tips?

Thanks,

=Chris Palmer

Hello @hana.lee73416

Posting your formula, and even a screen shot would be helpful to identify what's causing your issue.

hana.lee73416

very simple.

=Chris Palmer

Without seeing the data, I would verify the references on the sheets don't have duplicates. Index Match requires unique identifiers. In the {PDM_May2023} column, there may be duplicate values in the [KN Email]@row column as well.