Vlook up Do not show #N\A

[Eduards]

I have this code here;

Please Login or Register  to view this content.

It will show #N/A results for the look up values that doesn't exist, which makes sense.

How can this be re-written to only show available results and blank the cells that show as #N/A?

[CK76]

Use IFERROR to return blank. =IFERROR(Vlookup,"")

[Eduards]

Use IFERROR to return blank. =IFERROR(Vlookup,"")

Tried that already, error shows as 400

[CK76]

Hmm? I'm guessing you have wrong double quote syntax.
Try.

Please Login or Register  to view this content.

[Eduards]

Hmm? I'm guessing you have wrong double quote syntax.
Try.

Please Login or Register  to view this content.

How did that extra " at the end of the code made such a huge difference?