How to Catalogue Data without having to input manually

[shez_raz]

Hello!

I have a long list of ports (and the list keeps changing) which I have to catalogue it according to countries.
Is there any way I can do this, whether using a macro or even tools already built into Excel such as V-lookup?

All help will be GREATLY APPRECIATED!

Have attached a copy of my excel as well. Thank you!

[navn]

Does your list of berth columns contains duplicate, if no you can type this in H2 cell, =VLOOKUP(G2,$A$2:$B$72,2,FALSE), G2 is what berth you need to search and the $A$2:$B$72 is the range of your Berths and ports column

[shez_raz]

Hi NAVN!

My column contains duplicates.

I know there is a program for this function on Matlab but I really can't figure out an equivalent for EXCEL.
I have a vague idea of a macro that will cross reference a table containing ports with corresponding countries, so when i run the macro the corresponding countries will be returned in another column.

Anyone has any ideas how to do this?

[navn]

Hello,

Plz c da enclosed, hope dis helps u.

[shez_raz]

Hi again NAVN!

Thanks for the macro and that 'button' is so cool, will definitely be using that idea for future :D

Also, I have one more quick question. Can it be tweaked so that when users input the 'berths' the program will not be so sensitive? Like as long as it is similar inputs (whether or not caps etc), it can still recognise and return the correct country?

Right now for eg if i type 'bukom' instead of 'Bukom' the macro can't return a value coz it doesn't recognise it.