VBA for getting a source list populated on basis of Country

[Kavish Sekhri]

Hi All,
Can someone please help me with creating a macro for this...I am explaining the query w.r.t. excel sheet attached.

I work on data wherein I fill a CompanyID in excel (Column-A) and use plug-in to extract Company Name (Column B) and Country (Column C). Then, on basis of Country (Column C) I have to visit that respective country's web-link (listed in Sheet 2).

There are sources for almost all countries and I want to automate this thing so that on basis of the Country, its respective source list automatically auto-populates in the subsequent cell (Column D).

Also, Please suggest if some other automation can be applied to this.

An urgent reply would be appreciated.

Thanks
Kavish

 

[Luke M]

Welcome to the forum!
In D2, put this formula:
=VLOOKUP(C2,Sheet2!$A$2:$B$11,2,)

Adjust range of your table as needed, then copy down.

 

[Kavish Sekhri]

Welcome to the forum!
In D2, put this formula:
=VLOOKUP(C2,Sheet2!$A$2:$B$11,2,)

Adjust range of your table as needed, then copy down.

Thanks for the response Luke