Hi,
The empty value is because you have not given any criteria when the match
is not found.
For Example : Use this : =IF(ISERROR(MATCH(C1,$E$1:$E$99,0)),Not Found,C1)
Currently none of the values which you have in Column C are present in
Column E
Regards,
Sandeep
On Wednesday, 10 July
I missing in our formula (iserror)
=IF(ISERROR(MATCH(C1,$E$1:$E$99,0)),,C1)
.
Enjoy
Team XLS
On Tue, Jul 9, 2013 at 5:22 PM, raghunandan rallapalli
raghunandan.rallapa...@gmail.com wrote:
Sir, kindly give solution for the attached file,
thanks in advance
--