Help with Index / Match function

  • Thread starter Thread starter Livin
  • Start date Start date
L

Livin

I cannot get this to work... also my first ever attempt using Index &
Match

=INDEX(LinkedAttribs2003!$B$2:$B$59,MATCH(A2,LinkedAttribs2003!$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!
 
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
 
Back
Top