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!

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!

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!