Return an array based on a lookup
 

I need to return an array based on a vlookup for a match statement.
sheet 1 Monday
row1 9 10 11 12 13 14 15
monday tuesday
row2 tm1 w w w w w sheet 3 start
finish start finish
sheet 2 Tuesday tm1 10
15 11 15
row1 9 10 11 12 13 14 15

....
row5 tm1 w w w w

The 10 and the 15 are returned to sheet 3 using a match(tm1,2:2,0) formula.
The problem I have is the array in the match I can only do by manually
entering it. If tm1 is on a different row in sheet 2 it doesn't work as it
returns the wrong value.
I need to return the array for the match based on a lookup that finds tm1.
so on monday it returns 2:2, but on tuesday it returns 5:5 as the array
values.
Thanx in advance

Return an array based on a lookup
 

"seanss" wrote:

I need to return an array based on a vlookup for a match statement.
sheet 1 Monday
row1 9 10 11 12 13 14 15
monday tuesday
row2 tm1 w w w w w sheet 3 start
finish start finish
sheet 2 Tuesday tm1 10
15 11 15
row1 9 10 11 12 13 14 15

...
row5 tm1 w w w w

The 10 and the 15 are returned to sheet 3 using a match("w",2:2,0) formula.
The problem I have is the array in the match I can only do by manually
entering it. If tm1 is on a different row in sheet 2 it doesn't work as it
returns the wrong value.
I need to return the array for the match based on a lookup that finds tm1.
so on monday it returns 2:2, but on tuesday it returns 5:5 as the array
values.
Thanx in advance

Return an array based on a lookup
 

Sorry match("w",2:2,0) not match(tm1,2:2,0)

"seanss" wrote:

I need to return an array based on a vlookup for a match statement.
sheet 1 Monday
row1 9 10 11 12 13 14 15
monday tuesday
row2 tm1 w w w w w sheet 3 start
finish start finish
sheet 2 Tuesday tm1 10
15 11 15
row1 9 10 11 12 13 14 15

...
row5 tm1 w w w w

The 10 and the 15 are returned to sheet 3 using a match(tm1,2:2,0) formula.
The problem I have is the array in the match I can only do by manually
entering it. If tm1 is on a different row in sheet 2 it doesn't work as it
returns the wrong value.
I need to return the array for the match based on a lookup that finds tm1.
so on monday it returns 2:2, but on tuesday it returns 5:5 as the array
values.
Thanx in advance