adding information to a column from another columns/table

I have a list of orders, with order number, values etc. each on rows and need to add there also the country of the buyer. I have another list with two columns, order number and the country of the buyer next to that. So I would need to be able to add this country information to the correct row of a matching order number in the main list. How to do this, it is very slow to manually fill in and compare the lists.

Hi oksareiska and welcome to the forum.

There are multiple ways to solve this type of problem. VLookUp is one, XLookUp may also work for your data. If the file is very large or in multiple files or tables then Power Query may be a faster solution.
Watch:
https://www.youtube.com/watch?v=DDlZXXEI1bU for XLookup. If this doesn't make sense or apply to your problem, then give us a sample of your data and we can help more.