Derrick;405129 Wrote:
nevermind i see it at the bottom.

ok . so this works for an array, or a column that is continuous. if i
have
cells inbetween, (see my 2nd response to Luke, and luke's response to
Eduardo
for better details) where i dont want to check for numbers, but texts,
and so
its not as prettily organized, can we modify this formula?

so far im leaning towards using this formula, as its working the best
so
far. hahah
sorry luke. time to step up ur game :P
im a bit confused to the syntax still, but i think i can work around
it.

"NBVC" wrote:


Derrick;405046 Wrote:
help me out. something is off.. and giving me a different cell
name.

Ive changed it slightly to match my cells
-----------

=IF(ISNUMBER(MATCH(TRUE,INDEX(G6:N6=0,0),0)),ADDRE SS(6,MATCH(TRUE,INDEX(G6:N6=0,0),0),4),"sdfg")
-----------
right now i have numbers <0 in all, except N6 = 0. it returns
"H6"
close....but no cigar

can you explain how it works?
IF(this, then, else)
MATCH(lookup_value,lookup_array,match_type)
INDEX(array,row_num,column_num)
ADDRESS(row_num,column_num,abs_num,a1,sheet_text)

1. why the ...,index(G6:N6=0,0),... the =0,0 part.
2. why the ...,0),0),4),"sdfg") the ,4 part
thanks for your help!

"NBVC" wrote:


Possibly:


Code:
--------------------


=IF(ISNUMBER(MATCH(TRUE,INDEX(A6:C6=0,0),0)),ADDRE SS(6,MATCH(TRUE,INDEX(A6:C6=0,0),0),4),FORMULA)
--------------------


adjust range A6:C6 to suit.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)


------------------------------------------------------------------------
NBVC's Profile: 'The Code Cage Forums - View Profile: NBVC'
('The Code Cage Forums - View Profile: NBVC'
(http://www.thecodecage.com/forumz/members/nbvc.html))
View this thread: 'solving nested IF statements - The Code Cage
Forums' ('solving nested IF statements - The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh....php?t=112912))



Since you are not starting at column A, you will need to offset the
formula to look starting at column G


=IF(ISNUMBER(MATCH(TRUE,INDEX(G6:N6=0,0),0)),ADDRE SS(6,MATCH(TRUE,INDEX(G6:N6=0,0),0)+COLUMN(G6)-1,4),"sdfg")


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)

------------------------------------------------------------------------
NBVC's Profile: 'The Code Cage Forums - View Profile: NBVC'
(http://www.thecodecage.com/forumz/member.php?userid=74)
View this thread: 'solving nested IF statements - The Code Cage
Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=112912)



Try then:


Code:
--------------------
=IF(ISNUMBER(MATCH(1,INDEX((G6:N6=0)+ISTEXT(G6:N6) ,0),0)),ADDRESS(6,MATCH(1,INDEX((G6:N6=0)+ISTEXT(G 6:N6),0),0)+COLUMN(G6)-1,4),"sdfg")
--------------------


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112912