VLOOKUP does not work in IE

Question

VLOOKUP does not work in IE

yavisht opened this issue 8 years ago · 10 comments

yavisht commented 8 years ago

!ERROR is shown in IE when VLOOKUP is used. Is there a way to fix this?

Answer 1 · 2016-08-22T10:20:32.000Z

Hi @yavisht

which IE version, and what error do you get?

Answer 2 · 2016-08-22T11:08:02.000Z

I tested it in IE 11.. If we have a VLOOKUP formula in data-formula the value shown is !ERROR .. works fine in chrome and firefox. I tested the vlookup sample html as well.. same issues.

Answer 3 · 2016-08-22T23:10:59.000Z

yavisht commented 8 years ago

Answer 4 · 2017-02-17T18:49:06.000Z

Any ideas for a quick fix? Is it possible to set it to a javascript variable and display that? Or is just not able to do the lookup?

Answer 5 · 2017-02-20T01:01:57.000Z

I calculated figures in a hidden div and stole the values using jQuery using .value() as a workaround.

Answer 6 · 2017-02-21T01:43:19.000Z

That's fantastic. Could you post a link to see how it is done?

Answer 7 · 2017-02-21T02:01:48.000Z

Check the 2 examples. one with VLOOKUP and one without

custom-calc-example.zip

Answer 8 · 2017-02-21T18:33:56.000Z

Thanks so much for the examples. It now illustrates how much I need to get have VLOOKUP to work in IE.

Here is one of 80 rows I have to "convert".

<tr><td data-cell="F1" data-format="0.0000" data-formula="S1">S1</td><td data-cell="G1" data-formula="ABS(PMT(F1/12,360,J1))">G1</td><td data-cell="H1" data-formula="SUM(G1,L1,N1,O1)">H1</td><td data-cell="I1" data-format="0.00" data-formula="ROUNDUP(H1,-1)">260</td><td data-cell="J1" data-format="$0,0">25000</td><td data-cell="L1">58</td><td data-cell="N1">63</td><td data-cell="O1" data-formula="VLOOKUP(F1, P1:Q5, 2, TRUE)*J1/12">O1</td></tr>

Answer 9 · 2017-02-22T15:57:30.000Z

Sorry for late step in, I'll try to find the root cause of why it resulting error on IE (usually IE specific quirks)

Answer 10 · 2017-03-03T21:08:09.000Z

Maybe I can use the SERVER function to call a PHP version of VLOOKUP?