Index Match Query

[Areif]

Hi All,

I am trying to compare two list to get match data but unable to get the exact result i want
sample file is uploaded please check and correct my formula

 

[chirayu]

There's nothing wrong with your formula. Your data is the issue. You have V1 040 and V5 056 showing twice with 2 different customers. Index Match, like Vlookup will only take the first result.

 

[Naresh Yadav]

Hi,

Pls see attached file, if you don't have any issue using helper column
I have added helper column and use simple "Vlookup formula" to get desire result

regards
Naresh

 

[Areif]

Thanks Naresh
i got the result which i want