[Solved] Replace reference letters with words in drop list

Discuss the spreadsheet application

[Solved] Replace reference letters with words in drop list

Postby Fredrik Nilsson » Thu Apr 11, 2019 2:10 pm

Hi!

Is it somehow possible to replace ABCDEFGH in formula: FÖRSKJUTA('MATERIAL LISTA'.$K$95;VÄLJ(HITTA($C$13;"ABCDEFGH");0;27;54;78;90;111;147;166);0;VÄLJ(HITTA($C$13;"ABCDEFGH");26;26;23;11;20;35;18;14);1)

With:

ROSTFRITT
STÅL
ALUMINIUM
BRONS
MÄSSING
KOPPAR
TITAN
PLAST
Attachments
Text in drop list example 1.ods
(36.19 KiB) Downloaded 12 times
2.JPG
Last edited by Hagar Delest on Fri Apr 12, 2019 8:49 pm, edited 1 time in total.
Reason: tagged solved
Apache openoffice 4.1.1
Windows 10
Fredrik Nilsson
 
Posts: 12
Joined: Fri Mar 29, 2019 9:51 am

Re: Replace reference letters with words in drop list.

Postby MrProgrammer » Thu Apr 11, 2019 3:59 pm

Use MATCH instead of FIND. Be sure to use matchtype 0.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3813
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Replace reference letters with words in drop list.

Postby Fredrik Nilsson » Fri Apr 12, 2019 12:01 pm

HI!
Thanks!
Unfortunately, I can't get it work.

Do you have ability to help me with this?

B/R
Apache openoffice 4.1.1
Windows 10
Fredrik Nilsson
 
Posts: 12
Joined: Fri Mar 29, 2019 9:51 am

Re: Replace reference letters with words in drop list.

Postby RoryOF » Fri Apr 12, 2019 12:08 pm

Post your code, please.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29454
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Replace reference letters with words in drop list.

Postby robleyd » Fri Apr 12, 2019 12:34 pm

Or upload a sample spreadsheet - not an image - with sample data and examples of what you have unsuccessfully tried.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2942
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Replace reference letters with words in drop list.

Postby mikele » Fri Apr 12, 2019 1:20 pm

Hi,
with two additional columns ...
Attachments
Text in drop list example 1.ods
(53.3 KiB) Downloaded 11 times
LibreOffice 5.4.7 on LinuxMint/WinXP/Win7
mikele
 
Posts: 45
Joined: Wed Nov 21, 2018 11:11 am
Location: Germany

Re: Replace reference letters with words in drop list.

Postby Fredrik Nilsson » Fri Apr 12, 2019 2:24 pm

Thanks! Mikele
Thats a nice solution. :D
Apache openoffice 4.1.1
Windows 10
Fredrik Nilsson
 
Posts: 12
Joined: Fri Mar 29, 2019 9:51 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests