| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Having trouble getting MATCH to work with a variable lookup array
Hi -- I'm trying to use MATCH to return the column # of the first non-blank
cell in a row. It works great until I try to use a variable lookup array. =MATCH(TRUE,Budget!A85:E85<"",0) works great. I have a variable for the row # in A1. When I try this: =MATCH(TRUE,"Budget!A" & A1 & ":E" & A1<"",0) it returns #N/A Is what I am trying to do possible or do I just have a silly syntax error somewhere? -- TIA Chuck M. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Having trouble getting MATCH to work with a variable lookup array
Try with INDIRECT, viz, array-entered:
=MATCH(TRUE,INDIRECT("Budget!A" & A1 & ":E" & A1)<"",0) where A1 contains the row# -- Max Singapore http://savefile.com/projects/236895 Downloads:17,400 Files:358 Subscribers:55 xdemechanik --- "Chuck M" wrote: Hi -- I'm trying to use MATCH to return the column # of the first non-blank cell in a row. It works great until I try to use a variable lookup array. =MATCH(TRUE,Budget!A85:E85<"",0) works great. I have a variable for the row # in A1. When I try this: =MATCH(TRUE,"Budget!A" & A1 & ":E" & A1<"",0) it returns #N/A Is what I am trying to do possible or do I just have a silly syntax error somewhere? -- TIA Chuck M. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Having trouble getting MATCH to work with a variable lookup ar
Just what I needed!
Thanks Max. -- Chuck M. "Max" wrote: Try with INDIRECT, viz, array-entered: =MATCH(TRUE,INDIRECT("Budget!A" & A1 & ":E" & A1)<"",0) where A1 contains the row# -- Max Singapore http://savefile.com/projects/236895 Downloads:17,400 Files:358 Subscribers:55 xdemechanik --- "Chuck M" wrote: Hi -- I'm trying to use MATCH to return the column # of the first non-blank cell in a row. It works great until I try to use a variable lookup array. =MATCH(TRUE,Budget!A85:E85<"",0) works great. I have a variable for the row # in A1. When I try this: =MATCH(TRUE,"Budget!A" & A1 & ":E" & A1<"",0) it returns #N/A Is what I am trying to do possible or do I just have a silly syntax error somewhere? -- TIA Chuck M. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Having trouble getting MATCH to work with a variable lookup ar
Welcome, Chuck
-- Max Singapore http://savefile.com/projects/236895 Downloads:17,400 Files:358 Subscribers:55 xdemechanik --- "Chuck M" wrote in message ... Just what I needed! Thanks Max. -- Chuck M. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't get array formula to work in MATCH function | Excel Worksheet Functions | |||
| Text lookup array and match specific data | Excel Worksheet Functions | |||
| match, lookup or array? | Excel Worksheet Functions | |||
| table, index, array, match, lookup? | Excel Worksheet Functions | |||
| Variable Table Array in Lookup Function | Excel Worksheet Functions | |||
Linear Mode
