[Solved] Replace reference letters with words in drop list

Discuss the spreadsheet application
Post Reply
Fredrik Nilsson
Posts: 12
Joined: Fri Mar 29, 2019 9:51 am

[Solved] Replace reference letters with words in drop list

Post by Fredrik Nilsson »

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 71 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.

Post by Fredrik Nilsson »

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
User avatar
RoryOF
Moderator
Posts: 34570
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Replace reference letters with words in drop list.

Post by RoryOF »

Post your code, please.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
robleyd
Moderator
Posts: 5036
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Replace reference letters with words in drop list.

Post by robleyd »

Or upload a sample spreadsheet - not an image - with sample data and examples of what you have unsuccessfully tried.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
mikele
Posts: 72
Joined: Wed Nov 21, 2018 11:11 am
Location: Germany

Re: Replace reference letters with words in drop list.

Post by mikele »

Hi,
with two additional columns ...
Attachments
Text in drop list example 1.ods
(53.3 KiB) Downloaded 76 times
LibreOffice 5.4, 7.0, 7.2 on LinuxMint/Win10
Fredrik Nilsson
Posts: 12
Joined: Fri Mar 29, 2019 9:51 am

Re: Replace reference letters with words in drop list.

Post by Fredrik Nilsson »

Thanks! Mikele
Thats a nice solution. :D
Apache openoffice 4.1.1
Windows 10
Post Reply