|
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? |
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" wrote in message ... 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? |
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 "Bernie Deitrick" wrote: 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" wrote in message ... 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? |
| All times are GMT +1. The time now is 06:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com