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!