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.