Copper Contributor





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.

1 Reply


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)); "")