No you don't need code, look into Vlookup and Index, Match, hard to give you
an example without the actual data, just remember that with a Vlookup the
data you are looking up has to be the first column of the selection. Any
questions on them just ask.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"kaci" wrote:

Hello,

I have created a Master data worksheets, and one of the column in the master
worksheets indicates countries, for example Col A.
Then I have created a blank table in Worksheet 1, and in worksheet 1, column
B3 indicates the country code.
How can I look up the country code in Worksheet 1, then when the country in
worksheet 1 matches the Col A in the master worksheet, worksheet 1 will
display the data value of Col B, C, D, E in the maste worksheet. Same
countries appear different times in Col A of the master worksheet.

Do i need to write visual basic coding?

Million thanks.