Having trouble getting MATCH to work with a variable lookup array

C

Chuck M

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?
 

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

Similar Threads

Match Array returning #NA, Works individually 4
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
Match issue 3
=MATCH with nested arrays assistance needed 0
Index Match to ignore blank cells 0
lookup and return column number 2
First row where a cell is zero 2
MATCH to ignore blank cells in array 3

Top