error

[Timo_Slabinck]

I want to fill in the full name of the country with a formula, but I always get this warning "NB". It would be nice if you could help me with this problem.

[#2]

@Timo_Slabinck 

VLOOKUP can only look up to the right. You want to look up to the left.

If you have Microsoft 365 or use Excel Online:

=X.ZOEKEN($J1008; $J$2:$J$1001; $I$2:$I$1001; "")

If you have an older version:

=ALS.FOUT(INDEX($I$2:$I$1001; VERGELIJKEN($J1008; $J$2:$J$1001; 0)); "")