Description: 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 Actual Results: HLOOKUP reports "18" (in column T). Expected Results: Should be "19" (in column U). Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: 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 extensions: 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: Version: 5.1.6.2 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