How to know the Cell Address where Error will be Showing.

[Ashu K]

Dear All,

I have data like below in Column A & B

ITEM CODE	ITEM NAME
907000000000011	SUBMERSIBLE PUMP 5FT
904000000000001	C.FAN SEAIRA 600MM GLOSSY BROWN
904000000000016	C.FAN SEAIRA DLX 1200MM GLOSSY BROWN ISI
904000000000013	C.FAN SEAIRA 900MM WHITE
904000000000002	C.FAN SEAIRA 900MM IVORY
904000000000029	C.FAN SEAIRA 1200MM GLOSSY BROWN ISI
904000000000030	C.FAN SEAIRA 1200MM WHITE ISI
904000000000046	C.FAN SEAIRA DLX 1200MM IVORY ISI
904000000000060	C.FAN SEAIRA 600MM IVORY
904000000000073	C.FAN SEAIRA 600MM WHITE
904000000000131	C.FAN CHAMP AIR 1200MM BROWN ISI
904000000000028	C.FAN SEAIRA 900MM GLOSSY BROWN
904000000000017	C.FAN SEAIRA DLX 1200MM WHITE ISI
904000000000075	DELTA WALL FAN 300MM H/S
904000000000126	#N/A
904000000000134	#N/A
904000000000035	#N/A
904000000000117	#N/A
904000000000093	C.FAN BULLET 390 1200MM MATT BROWN
904000000000088	C.FAN EURO 1200MM PEARL IVORY ISI

I want output like below in other sheet. Want Cell Address where Error will be showing.

ERROR REPORT

Error Display in below cel no

$B$19

$B$20

$B$21

$B$22

Thanks & Regards

Ashu Kenith

[Ashish Kumar]

[Ashish Kumar]

Hi,

Check this..!

Note : Please visit the group page for download the sheet.

Regards

Ashish Kumar

On Tuesday, August 23, 2016 at 5:58:58 PM UTC+5:30, Ashu K wrote: