Ask Your Question
0

FALSE/ #N/A CELL

asked 2019-01-31 14:18:32 +0100

Aminda gravatar image

Hi there! How do I hide the false cell before complete. This is formula. =VLOOKUP(A8.{"z"\"#N/A";"Paris"\"France";"London"\"UK";"Buenos Aires"\"Argentina";"Lisbon"\"Portugal";"other_place"\"other_country"}.2.0)

Thank you!

edit retag flag offensive close merge delete

Comments

"How do I hide the false cell before complete." I don't understand. What is a "false cell"? What do you mean by "before complete"?
Did you ever succeed using a point (full stop) in place of the parameter delimiter? You shouldn't. Replace the points with semicolons.
What are the backslashes supposed to mean? What are your settings under Tools>Options>LibreOffice Calc>Form ulae>Separators?

It's your responsibility to ask clear questions.
See https://ask.libreoffice.org/en/questi... e.g.

Lupp gravatar imageLupp ( 2019-01-31 19:50:30 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-01-31 20:07:17 +0100

Lupp gravatar image

Don't try to use inline arrays in place of lookup tables. That's very limited and inefficient.
If you use inline tables at all, you need to use the correct separators.
The separator behind Array column: must be used beween the columns of any row.
The separator behind Array row: ends one rtow and starts the next one.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-01-31 14:18:32 +0100

Seen: 17 times

Last updated: Jan 31