Index needs a little help
 

OK ... I'm using this to find and return a particular cell that matches
the given criteria ...

=INDEX($E$34:$E$545,MATCH(1,($D$34:$D$545=1)*($G$3 4:$G$545=AL1),0))

it works perfect for doing just that, but it needs a little more. I
need it to return the word "blank" if the cell it's referencing is
empty, and if it isn't empty then to just go ahead and return what is
in the cell. Thanks


--
Reignman
------------------------------------------------------------------------
Reignman's Profile: http://www.excelforum.com/member.php...o&userid=21023
View this thread: http://www.excelforum.com/showthread...hreadid=385113

Try, array-entered (i.e. press CTRL+SHIFT+ENTER):
=IF(ISNA(MATCH(1,($D$34:$D$545=1)*($G$34:$G$545=AL 1),0)),"blank",INDEX($E$34
:$E$545,MATCH(1,($D$34:$D$545=1)*($G$34:$G$545=AL1 ),0)))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Reignman" wrote in
message ...

OK ... I'm using this to find and return a particular cell that matches
the given criteria ...

=INDEX($E$34:$E$545,MATCH(1,($D$34:$D$545=1)*($G$3 4:$G$545=AL1),0))

it works perfect for doing just that, but it needs a little more. I
need it to return the word "blank" if the cell it's referencing is
empty, and if it isn't empty then to just go ahead and return what is
in the cell. Thanks


--
Reignman
------------------------------------------------------------------------
Reignman's Profile:
http://www.excelforum.com/member.php...o&userid=21023
View this thread: http://www.excelforum.com/showthread...hreadid=385113