I am having a similar issue, and am NOT good with functions....
I have a list of 5522 Codes which have their corresponding gender next to them. I have another list of 1046 codes that I would LIKE to have their genders next too. All 1046 codes are in the 5522 list of codes. How can I match the the codes in these two columns so I can have genders for teh 1046 codes?
ex. I have this...
How can I get the correct genders with the correct numbers in the second list?