Help with Index / Match function
I cannot get this to work... also my first ever attempt using Index &
Match =INDEX(LinkedAttribs2003!$B$2:$B$59,MATCH(A2,Linke dAttribs2003!$A$2:$A $59,0),MATCH($B$1,$2:$2,0)) within same XLS... 2 sheets (Mappings & LinkedAttribs2003) Mapping has 2 columns like this... Attribute | LinkID LinkedAttribs2003 has 2 columns like this... ldapdisplayname | LinkID Since the LinkedAttribs2003 sheet has less, there is no a 1-1 match with Mappings; thus I want to search the LinkedAttribs2003 'ldapdisplayname' column for a match to the 'Attribute' column in Mappings. If there is a match, then pull the LinkID from LinkedAttribs2003 and populate the corresponding 'LinkID' on the appropriate 'Attribute' thanks in advance! |
Help with Index / Match function
I think you need VLOOKUP:
=VLOOKUP(A2,LinkedAttribs2003!$A$2:$B$59,2,0) This will return the LinkID corresponding to the matched "Attribute" (A2) In case of error (no match) =IF(ISNA(VLOOKUP(A2,LinkedAttribs2003!$A$2:$B$59,2 ,0)),"No match",VLOOKUP(A2,LinkedAttribs2003!$A$2:$B$59,2,0 )) HTH "Livin" wrote: I cannot get this to work... also my first ever attempt using Index & Match =INDEX(LinkedAttribs2003!$B$2:$B$59,MATCH(A2,Linke dAttribs2003!$A$2:$A $59,0),MATCH($B$1,$2:$2,0)) within same XLS... 2 sheets (Mappings & LinkedAttribs2003) Mapping has 2 columns like this... Attribute | LinkID LinkedAttribs2003 has 2 columns like this... ldapdisplayname | LinkID Since the LinkedAttribs2003 sheet has less, there is no a 1-1 match with Mappings; thus I want to search the LinkedAttribs2003 'ldapdisplayname' column for a match to the 'Attribute' column in Mappings. If there is a match, then pull the LinkID from LinkedAttribs2003 and populate the corresponding 'LinkID' on the appropriate 'Attribute' thanks in advance! |
Help with Index / Match function
Your formula works for me, but you have to have the same value in A2 and B1.
Take a look at these: http://www.ozgrid.com/Excel/left-lookup.htm http://www.contextures.com/xlFunctions03.html http://office.microsoft.com/en-us/ex...549021033.aspx -- RyGuy "Livin" wrote: I cannot get this to work... also my first ever attempt using Index & Match =INDEX(LinkedAttribs2003!$B$2:$B$59,MATCH(A2,Linke dAttribs2003!$A$2:$A $59,0),MATCH($B$1,$2:$2,0)) within same XLS... 2 sheets (Mappings & LinkedAttribs2003) Mapping has 2 columns like this... Attribute | LinkID LinkedAttribs2003 has 2 columns like this... ldapdisplayname | LinkID Since the LinkedAttribs2003 sheet has less, there is no a 1-1 match with Mappings; thus I want to search the LinkedAttribs2003 'ldapdisplayname' column for a match to the 'Attribute' column in Mappings. If there is a match, then pull the LinkID from LinkedAttribs2003 and populate the corresponding 'LinkID' on the appropriate 'Attribute' thanks in advance! |
All times are GMT +1. The time now is 07:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com