This post was automatically translated into English.
Hello everyone,
I have the following problem with -REFERENCE-.
I would like to use LOOKUP to transfer a number from a sorted list to another list. A name is entered in the second list that is not present in the first list.
That's why there should be a zero or an empty cell for this name in the second list.
See attached file.
The letter F is missing in the table (A1:B12) = List 1. From here the reference to column E should be transferred to the names in column D. The letter F appears in the second list.
There should be a zero or an empty cell in the cell (column E).
I hope that someone can help me with this.
Appendix is included.
Thank you spriha
[Solved] LOOKUP in LO Calc
[Solved] LOOKUP in LO Calc
- Attachments
-
- Vereinswertung.ods
- (11.19 KiB) Downloaded 51 times
Last edited by MrProgrammer on Tue Feb 20, 2024 5:11 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
LibreOffice 7.5.9.2 on WIN 10
Re: LOOKUP in LO Calc
Hallo
Start in E1 with:
and pull down
Start in E1 with:
Code: Select all
=WENNNV(SVERWEIS(D1;$A$1:$B$13;2;0);0)
# en
=IFNA(VLOOKUP(D1;$A$1:$B$13;2;0);0)
Libreoffice 7.4 on Debian 12 (Bookworm) (on RaspberryPI4)
Libreoffice 7.6 flatpak on Debian 12 (Bookworm) (on RaspberryPI4)
Re: LOOKUP in LO Calc
It's the same LOOKUP function since the very first version of Visicalc in the year 1979 and successive spreadsheet applications such as Lotus 1-2-3, Excel and Calc. LOOKUP never did what most users expect it to do.LOOKUP in LO Calc
In your specific example =CODE(D1)-43 returns a correct result without any lookup table.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice