HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA
SOURCE CELL ACTION TO BE TAKEN
--------------------------- ---------------------------------
IEJFIEA1ERBERIT A1 FOUND THEN PRINT A1 HERE
ZIDFDB1DIBR B1 FOUND THEN PRINT B1 HERE
IC1FDBRS C1 FOUND HERE PRINT C1 HERE
DFDIBR45466SDFIB HAS NEITHER A1, B1 OR C1, PRINT D1 HERE
------------------------------------------------------------------------------------------
The problem is checking for D1 returns "VALUE! and I am stuck there. How can
this be achieved?
|