Hi,
I enter text onto M8 -
I then use this formula to decide what to show in Q8
- =IF(ISNUMBER(SEARCH("B",M8)),"Exceeding 3 hours",IF(ISNUMBER(SEARCH("C",M8)),"Disabled zone / No permit",IF(ISNUMBER(SEARCH("D",M8)),"No Parking Zone","")))
That works fine
What I need to do is,
copy the result -eg. "No Parking Zone" into a holding cell , S2 , I have a macro that uses S2 to print template
(the reason I need a "holding" cellis , I would then like to go to the next row and do it again etc. )
It has to be a formula because i need it to update for each row.
i have tried =if,M8<>"",S2=Q8,"") - but, i get "False" and S2 is left blank
Sorry for the long winded explanation
Hope it makes sense
Cheers
I enter text onto M8 -
I then use this formula to decide what to show in Q8
- =IF(ISNUMBER(SEARCH("B",M8)),"Exceeding 3 hours",IF(ISNUMBER(SEARCH("C",M8)),"Disabled zone / No permit",IF(ISNUMBER(SEARCH("D",M8)),"No Parking Zone","")))
That works fine
What I need to do is,
copy the result -eg. "No Parking Zone" into a holding cell , S2 , I have a macro that uses S2 to print template
(the reason I need a "holding" cellis , I would then like to go to the next row and do it again etc. )
It has to be a formula because i need it to update for each row.
i have tried =if,M8<>"",S2=Q8,"") - but, i get "False" and S2 is left blank
Sorry for the long winded explanation
Hope it makes sense
Cheers
Last edited: