How to get cells with static data to stay in the row it correlates to

I have a dynamic spreadsheet where columns A-K dynamically update and change. However I have one column where static data is entered manually (Quantity) and I cannot figure out how to get the static data to stay in the same row as the dynamic data that it correlates to.

So basically I have column L which is the quantity of each item and I am trying to get the quantity of item (x) to stay in the same row as (x) where (x) is always changing rows when the dynamic data updates, however the static data (quantity) is not moving to the row of the item it previously corresponded to.

Any help with this would be greatly appreciated.

This is solved, I was able to solve the above with the following.

=INDEX('Add-Quantities-Here'!$ED$2:'Add-Quantities-Here'!$ED$1010,MATCH($B$2:$B$1002,'Add-Quantities-Here'!$A$2:'Add-Quantities-Here'!$A$1000,0))

Although I have one issue I would like to resolve in this formula.

I need to add an IF(ISERROR) function so that if there is no MATCH then result returns a 0 instead of an N/A.

I've tried for quite some time to add an IF(ISERROR) function but couldn't get the correct resolution.

Originally Posted by bhenlee

try this:

=IFERROR(INDEX('Add-Quantities-Here'!$ED$2:'Add-Quantities-Here'!$ED$1010,MATCH($B$2:$B$1002,'Add-Quantities-Here'!$A$2:'Add-Quantities-Here'!$A$1000,0)),0)

That worked perfectly. Thanks