Return an array based on a lookup

S

seanss

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
 
S

seanss

seanss said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top