Hi guys,
I need to create dummy-variables of adresses in a dataset. How i plan to do this is searching the adress cell and check if it contains a postnumber from a list of postnumbers and then either return 1 or 0 into the result cell.
I tried using =IF(ISNUMBER(SEARCH())) but if i put in a list of objects to search for the postnumbers) then it will return a "SPILL" error.
Basicly it seems using this function this way creates a corresponding amount of result cells to the amount of objects it is searching for.
I need a function or method that only writes 1 or 0 to one result cell if any of the numbers searching for is found.
Grateful for all help.
Bookmarks