HLOOKUP reports value in next to last column and not the last column. Tried to extend table to 22 columns and all values reported correctly expect column 20.
Steps to Reproduce:
1. Cell contents:B1 is 88F6X378V+MQ,
G1 is "=MID($B1,5,1)" displayed "X", G2 is "=VALUE(G1) dispalyed "Error:502", G3 is "=ISERROR(G2)" displayed "TRUE", G4 is "=IF(G3=0,HLOOKUP(G2,$B17:$U18,2),HLOOKUP(G1,$B17:$U18,2))" displayed "18"
2.Table is Google "Plus Code" lookup table and is rows 17 & 18, columns B through U
HLOOKUP reports "18" (in column T).
Should be "19" (in column U).
User Profile Reset: Yes
OpenGL enabled: Yes
Reported value in cell U18 which is "19".
OpenGL vendor string: nouveau
OpenGL renderer string: NV4C
OpenGL version string: 2.1 Mesa 18.0.5
OpenGL shading language version string: 1.20
OpenGL ES profile version string: OpenGL ES 2.0 Mesa 18.0.5
OpenGL ES profile shading language version string: OpenGL ES GLSL ES 1.0.16
OpenGL ES profile extensions:
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial3
CPU Threads: 2; OS Version: Linux 4.4; UI Render: default;
Locale: en-US (en_US.UTF-8); Calc: group
Thank you for your bug report. Please attach a test file so that other contributors can try to confirm it.
Status set to NEEDINFO, please set it back to UNCONFIRMED once requested
informations are provided.
Best regards. JBF