Maybe something like:
IF(ISERROR(...),"",(...))
jarviscars Wrote:
Thanks for that..... Works great!
Could you please help me with an IF statement to return an empty cell
if the formula evaluates to false??? (at the moment the cell returns
#NUM if it does not evaluate to true.
Code:
--------------------
=INDEX('Cars without Photos'!$A$1:$H$500,SUMPRODUCT(SMALL(ROW('Cars without Photos'!$3:$500)*('Cars without Photos'!$B$3:$B$500=" Jarvis Gepps Cross"),COUNTA('Cars without Photos'!$B$3:$B$500)-COUNTIF('Cars without Photos'!$B$3:$B$500," Jarvis Gepps Cross")+ROW()+500-COUNTA('Cars without Photos'!$B$3:$B$500)-2-2)),COLUMN())
--------------------
Cheers,
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=390438