Using Index() & Match() functions

I am trying to populate columns on sheet1 from a second worksheet(sheet2) using the INDEX() and MATCH() combination in a formula. The source is from a listbox populated from a named range on another sheet(sheet3).

For example:

A2 would be the list box selected and would say "Monday" I want B2 to populate from a second sheet by finding the reference against Monday on that sheet.

So far I have tried the following with out success

=index($a$2:$a$8(Match(sheet2!$b$2:$b$8,0),1)

Sheet2 would typically be:

A2 B2
Monday One
Tuesday Two
Wednesday Three
Thursday Four

and so on.

Any ideas where I'm going wrong out there?????

Originally Posted by Walter349

I am trying to populate columns on sheet1 from a second worksheet(sheet2) using the INDEX() and MATCH() combination in a formula. The source is from a listbox populated from a named range on another sheet(sheet3).

For example:

A2 would be the list box selected and would say "Monday" I want B2 to populate from a second sheet by finding the reference against Monday on that sheet.

So far I have tried the following with out success

=index($a$2:$a$8(Match(sheet2!$b$2:$b$8,0),1)

Sheet2 would typically be:

A2 B2
Monday One
Tuesday Two
Wednesday Three
Thursday Four

and so on.

Any ideas where I'm going wrong out there?????

suppose Moday in entered in C2 and list of data is in A2:B8
try this

=INDEX($A$2:$B$8,MATCH(C2,$A$2:$A$8,0),2)

you should adjust references according to your data (I supposed a single sheet in above formula)

Regards.