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