Index needs a little help

R

Reignman

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$34:$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
 
M

Max

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