Merging Data for match cases-Vlookup

[Bishnu Adhikari]

Hello,

I was trying to match and merge/get the data using vlookup but it is not working for me. I know, there is something minor thing that I am missing.

I have attached a sample file for reference.

Thank you in advance.

[TMS]

Try this:

Please Login or Register  to view this content.

[Bishnu Adhikari]

Thank you, @TMS.

It returns the values if present, which is excellent, but it returns 0 instead of "Empty" for [if_not_found].

Thank you

[windknife]

Clear all expected data in column B
B2
=LET(A,A2:A1000,
B,XLOOKUP(A,Source!$K:$K,Source!$E:$E,""),
IF(B="","",B))

[TMS]

but it returns 0 instead of "Empty" for [if_not_found]

I suspect you will find that the record is there but the associated matched cell is blank. In that case you will get a zero returned. windknife has provided the solution for this scenario (and extended the range so it is one formula).

[TMS]

You're welcome. Thanks for the rep.