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.

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.

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.

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.