Calculator for price list - dynamic

Hi,

You either made some errors in the description or haven't shown what your workbook really does (there is no formula referring to column O) you mentioned: "if I put the quantity in the column O"
That is why despite of several downloads of the attachment and number of visits to your thread there was no answer for quite some time (as for this forum standards).

Let me try to guess:

As a general concept - you do not need columns I:L in Arkusz3. The same result could be obtained with MATCH function.

But before you delete columns - write number in M4 and try in N4 formula:

Please Login or Register  to view this content.

As you copy it down you notice it shall be a bit more complicated in real life to take care of empty quantities - for instance (if you have english version of Excel Translate yourself - jeżeli.błąd function -> IFERROR)

Please Login or Register  to view this content.

PS. I checked it also after unprotecting the sheet (a general advice - posting protected workbook and not sharing password with other users significantly decreases chances for answer :-P )

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.