| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare data in two worksheets to find matching cells? | Excel Discussion (Misc queries) | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
| how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) | |||
| What function or formula do I use to calculate ROI with this data? | Excel Worksheet Functions | |||
Hybrid Mode
