Hello,
I have a column that is a list of countries and another adjacent column with tax numbers for each country. I have another column which is the same list of countries but in a different order.
I want to automatically add the tax numbers to this reordered list of countries in the correct order. Can someone please explain how to do this? I tried vlookup, but it doesn't look like this is the right command.
Thanks very much.
Alex
Hi akboche,
Welcome to the Forum!
I would use VBA with a Dictionary.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
If the countries' names are spelled the same then
vLLOKUP seems the right command. send a sample and it will be solved!1
Here is the sample
thanks
sample.xlsx
Try this, copied down...
=VLOOKUP(D1,$A$1:$B$29,2,0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Here's a VBA Dictionary solution:
Directions for running the routine(s) just supplied
Please Login or Register to view this content.
If you haven't used macros before you'll need to go to your options - trust center -trust center settings - macro settings
, the second option down (disable all macros with notification)
Then - Copy the code to the clipboard
Open your Workbook
Press ALT + F11 to open the Visual Basic Editor.
Select "Module" from the Insert menu
Type "Option Explicit" then paste the code under it
With the cursor between Sub and End Sub press F5 (F8 to Single Step)
OR
Press ALT + Q to close the code window.
Press ALT + F8 then double click on the macro name
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks