HOW TO USE FIND OR SEARCH FUNCTION TO FILL DATA

[hsg]

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 HER

 

[Bernie Deitrick]

hsg,

If your source cell is A10, then use the formula:

=IF(ISERROR(FIND("A1",UPPER(A10))),IF(ISERROR(FIND("B1",UPPER(A10))),IF(ISER
ROR(FIND("C1",UPPER(A10))),D1,C1),B1),A1)

HTH,
Bernie
MS Excel MVP

 

[hsg]

Hello Bernie,

THANX a lot. It worked ! Only I had written problem wrongly. The action was
actually print "A1", "B1", "C1" or "D1" or any text of my choice. I changed
accordingly, and it worked.

harsh