× WooPrice Calculator PRO

[SOLVED] Problems with Excel function HLOOKUP

Start
Prev
1
Next
End

Enrico
Offline

3 years 4 months ago #757 by Enrico

Enrico replied the topic: [SOLVED] Problems with Excel function HLOOKUP

Hi Dominik,

You just need to upgrade your AWS Price Calculator to the new version which solve your problem.

You need to upgrade your plugin to 2.0.8

Best regards,
Enrico

Please Log in or Create an account to join the conversation.

Lutfun Shorna

3 years 4 months ago #747 by Lutfun Shorna

Lutfun Shorna replied the topic: [SOLVED] Problems with Excel function HLOOKUP

Hi Dominik,
could you please send us to hello@altoswebsolution.com your excel file with your calculation .so we can look over that.

regards
lutfun shorna

Please Log in or Create an account to join the conversation.

Dominik
Topic Author
Offline

3 years 4 months ago #746 by Dominik

Dominik created the topic: [SOLVED] Problems with Excel function HLOOKUP

Hi,

in my Excel File im using calculation with the HLOOKUP function.

=IF(D6=0;0;HLOOKUP(D6;$B$19:$CA$122;MATCH($D$4;$A$22:$A$122;-1)+3))

I splitted up the nested funtions and recognized that the HLOOKUP functions returns a #REF! Error.

Excel, LibreOffice and OpenOffice is showing the right result. Just the WooPriceCalculator showing this Error.

Hope you can help me.

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Moderators: david

Time to create page: 0.221 seconds

[SOLVED] Problems with Excel function HLOOKUP

Cart

Login