Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
Min formula not returning value from Index | Excel Worksheet Functions | |||
how do i turn the help index on again? | Excel Discussion (Misc queries) | |||
Vlookup, Index & Match | Excel Worksheet Functions | |||
index to a range of cells | Excel Worksheet Functions |