Hello,
I have a list of companies holding shares of another company. The companies in the different years all have different ID's and I want to standardize the lists, so all the firms have the some ID in all the years. For example, Macroware should be ID 5 in 1996, 2001, 2006 and 2011. I already know what the ID of each firm is in each of the unstandardised lists. I can't seem to figure out how to do it. I hope somebody can help me.
I added an example file.
Kind regards,
Bremster
To lookup the new UNIVERSAL ID for "62" located on sheet Example 1996, the formula would be:
=INDEX('Years linked'!$A:$A, MATCH(A1, 'Years linked'!B:B, 0))
The INDEX() range will always be column A on the "years" sheet, but the MATCH() column changes based on the sheet you're putting a formula in.
You can take it from there.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I'm afraid I could do with a bit more guidance as I am rather clueless.
Apparently there is an error in the formula according to excel?
Nope, works fine. As noted, you have to adjust the MATCH column range for each sheet to match to the correct column on the main sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Bremster 
Register To Reply
Bookmarks