[Solved] VLOOKUP cannot find "A (low)" or "A (high)"

[ruub7]

Hello,

I am trying to convert selections from a dropdown menu (text) to a numerical value, so I can use this as input for calculations.

I don't know if this is the easiest or best way to do it, but I used a VLOOKUP function to try and convert the text from the dropdown menu to a value.
I thought this would be very simple, but it sometimes gives errors and sometimes it just completely returns the wrong value...

So I have made a simple version of the real file to show what the issue is.

Hopefully you'll be able to figure out what I am doing wrong...

Edit: Changed subject, was VLOOKUP with dropdown menu  Make your post understandable by others  -- MrProgrammer, forum moderator

[MrProgrammer]

Hi, and welcome to the forum. Thank you for the attachment.

it sometimes gives errors and sometimes it just completely returns the wrong value

[Tutorial] VLOOKUP questions and answers, especially Q6/A6

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[ruub7]

Thanks, that solved the problem!

Silly question:
Why is this option automatically on, when it is an option that most users want/need to have disabled for their formula's to work properly according to that tutorial?

[karolus]

Hallo

For what reason do you imply: "most users do not need this feature"?

[Villeroy]

Most users don't know what it is and it is difficult to understand why search expressions fail when they include some special characters such as braces, plus sign and dots. LibreOffice turned it off by default. Anybody who still insists in using OpenOffice has to cope with weird defaults and missing functionality.