VLOOKUP does not work in IE

[yavisht]

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

[ikhsan017]

Hi @yavisht

which IE version, and what error do you get?

[yavisht]

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.

[yavisht]

[bwente]

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?

[yavisht]

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

[bwente]

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

[yavisht]

Check the 2 examples. one with VLOOKUP and one without

custom-calc-example.zip

[bwente]

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>

[ikhsan017]

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

[bwente]

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