| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return values from an array based on matching text value | Excel Worksheet Functions | |||
| Lookup Value in Range/Array and Return Column Header Value | Excel Discussion (Misc queries) | |||
| Lookup Value in Range/Array and Return Column Header Value | Excel Worksheet Functions | |||
| Return a cell value based on specific combinations of cells in an array | Excel Worksheet Functions | |||
| return array result in cell based on comparing dates | Excel Worksheet Functions | |||
Linear Mode
