Help with Index / Match function

[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!

 

[Guest]

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

 

[Guest]

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/excel/HA011549021033.aspx