Consecutive lookup gives errors

Hi,

I use a lookup function to fill values on a worksheet, SecOS using values from a 2nd worksheet, HQLA_Equity. It works fine.

On the same worksheet,SecOS , I use another lookup using values from a 3rd worksheet, BRisk.
When the code executes this, it alters the values filled from first lookup

<code>

Please Login or Register  to view this content.

</code>