Look up Function
Kaci
Vlookup will only return 1 row. For the second entry you need to modify the
vlookup to find the next item.
The real question is there a maximun of 2 lines in the master table or more
and is the master table sorted so that the first find matched country
gurantees that the next line will show the same country if it is the same.
(ie ordered or not ordered).
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.
"kaci" wrote:
My master table look like this
Japan 12 51
Japan 18 42
US 20 30
Where Japan is Col A, 12 is Col B, and 51 is Col C.
When I use vlookup as "=VLOOKUP(Japan,Sheet1!A:F,2,0)", the first row
returns 12, and the second row returns 12 as well.
Please kindly advise.
"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.
|