I have a FeatureID (column A) in one tab, and an Alix ID (column J) that is empty. In a separate tab, I have a list of the Alix IDs, and they correspond to FeatureIDs. Unfortunately, there is oftentimes a 1 to many relationship between Alix IDs and Feature IDs (IE, 3 Feature IDs for each Alix ID).
I need to be able to pull the Alix ID and have it fill in Column J every time there is a corresponding FeatureID.
Any suggestions?
Why not use a pivot table for this?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Attach a sample workbook. Make sure there is just data to demonstrate your entire scenario. Mock up some of your desired results manually so we can see your stated goal.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
_________________
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've attached an example. I need the "AlixID" column populated with the info from the Alix IDs tab. Also, is there a way to make multiple Alix IDs show up in the "AlixID" column on the Master tab if there are such instances? That is less important and secondary, but would be awesome if possible!
To get the first/primary match, this in B2, copied down:
=IFERROR(INDEX('Alix IDs'!$A$2:$A$7,MATCH("*"&$A2&"*",'Alix IDs'!$B$2:$B$5,0)),INDEX('Alix IDs'!$A$2:$A$7,MATCH($A2,'Alix IDs'!$B$2:$B$5,0)))
Thanks so much! Really appreciate it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks