Hello, i'v got this formula: =OM(ÄRFEL(SÖK("*Slägghammare*";$C$1:$C250;1));"";"Sledge hammer").
I am searching for "Slägghammare" in C column and in the same sheet and if this value exists then it get translated in to "Sledge hammer" in the netx column, and this works fine.
But how can i get this value from another sheet? e.g, sheet1.
Thank you.
Regards
//Patrik.
Bookmarks