× WooPrice Calculator PRO

[SOLVED] Problems with Excel function HLOOKUP

Start
Prev
1
Next
End

Enrico
Offline

2 years 10 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

2 years 10 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

2 years 10 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.172 seconds

[SOLVED] Problems with Excel function HLOOKUP

Cart

Login