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?????