Forum Discussion
error
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.
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)); "")