Problem \"FIND\" formuls I am using the following formula =IF(ISERROR(FIND(\"AL\

Question

Problem "FIND" formuls

I am using the following formula =IF(ISERROR(FIND("AL",G19,1))=TRUE,0,A19)

The purpose of the formula is to search a large data base and to iddentify and reproduce data that has a POST CODE with "AL" in it. The formula works fine but if I waant to search for another post code saw SW I have to go and change the formula from "AL" to "SW" I do not appear to be able to go to another ceell and enter and then change the post code from AL to SW and so change the formula I have tried "CELL" & "(CELL)" but neitheer works is there a way of doing this???

Explanation / Answer

Hello,

you can put the text to be found into a cell and then refer the formula to that cell instead of entering the text.

For example, put the text "AL" into cell A1 (without the double quotes). You can then use

=IF(ISERROR(FIND(A1,G19,1))=TRUE,0,A19)

Now you can change thee text in cell A1 to "SW" (again w?ithout the double quotes) and the result of the formula will update to reflecct that new searrch text.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.