Drop down list + vlookup function + loop

[Excelicious]

Hello guys,

Im working on a file where I created a dropdown list (country and Currency). So I set the column A for country and column B for Currency. I created a drop down list for country in column A of course. Now the logic is for example assuming that if I choose USA from the drop down list I would like to display in column B the currency which is USD. Now this can be done by using VLOOKUP of course but the thing is that I am working on a workbook where there are over 100k lines so copying and pasting the VLOOKUP function for 100k lines is not the solution and the file will be way too heavy and it will lag.

So the question: Is there a possiblity to apply the VLOOKUP function as Macro with a loop?

The logic for that will be I think: For each cells, If we choose country (from column A - drop down list) then display currency (in column B).

The logic sentence sounds easy but I am a noobie and I just had a basic training with VBA language but still I don't know where to start with this. So can someone help me resolve this issue?

[Excelicious]

No one? :x

[noobtime]

Is your currency set by the country? or would you have multiple currencies within one country?

If its singular you could use a macro to: search/replace > "USA" with "USA - USD" then your drop down would read the country name along with the currency.

This could be based on a pre determined list of countries with set currencies

maybe not what you're after but also noob...