Formula help?

[JennivL]

Dear community,

Looks like I just can't figure this out in a reasonable time... best to admit my failures and ask for help.

Could you tell me: How to look up a specific value in column cells and return a predetermined value to a corresponding cell in another column if true?

Example: Column A containing emails -> Lookup if cells have emails including endings ".fi" -> Return value "Finland" in column B in the corresponding cell when true. 

Seems simple... but no... Help please?

[#2]

@JennivL -

You could do as:

=IF(ISNUMBER(IFERROR(FIND(".fi",A2,1),FALSE)),"Finland","NOT Finland")

I've left Column B to show the logic.

Demonstrated in the file attached. 

[#3]

@ChrisMendoza Thank you! Works perfect:)) So happy right now:)