[Solved] VLOOKUP Text w/ + Operator

[brantlymedders]

I'm having some issues with VLOOKUP.

Essentially, I have a spreadsheet with two sheets, designated Rubric and Data.

Rubric looks like this:
Column C contains a dropdown list with the following possibilities: A+, A, A-, B+, B, B-, C+, C, C-, D+, D, D-, F.
Column D contains the following formula: =VLOOKUP(C5, Data!A2:B14, 2, FALSE)

Data Looks like this:
Column A lists A+, A, A-, B+, B, B-, C+, C, C-, D+, D, D-, F.
Column B lists these decimals that correspond to the above letter values: .98, .95, .92, .88, .85, .82, .78, .75, .72, .68, .65, .62, .55

However, when I use the VLOOKUP function on any value containing the "+" (i.e. A+, B+, C+, D+, I get the value that would correspond to the unmodified value (i.e. A+ yields .95, which should correspond to A, B+ yields .85, which should correspond to B). Interestingly enough, the values containing "-" work fine.

Lastly, these formulas work perfectly in Google Docs.

I have the cells that contain the letter values formatted as text in both sheets.

Can someone help me sort this issue out?

[Villeroy]

Tools>Options>Calc>Calculation
Turn off all check boxes except the "Match Whole Cell" option.

[JohnSUN-Pensioner]

Welcome to forum!

Try to disable "use regular expressions in formulas"to this workbook

Oh! Villeroy shoots faster ...

[gerard24]

+ is a special character.

1. Menu Tools > Options > LO Calc > Calculate, turn of "Enable regular expressions in formulas".
or
2. Replace =VLOOKUP(C5, Data!A2:B14, 2, FALSE) by

=VLOOKUP(SUBSITUTE(C5,"+","\+"), Data!A2:B14, 2, FALSE)

Special characters are . ^ $ * + ? \ [ ( { | , use escape character \ before special characters if regular expressions is enabled.

[brantlymedders]

Thank you all so much for your help.