When changing a cell on table in Sheet1, index match vba function doesnt trigger in sheet2

Hi, i have this code. In sheet1, there is a table called auto_price_list (in macro screen this is range("a1:dd10000")) for example audi a4 price.

While i am in sheet2, i am writing this function referencing Sheet1.range("a1:dd10000") (i do this with "index_func1()" with a vba code), and it works perfectly. when i change the data in sheet2 (for example sheet2!Z5="Audi A4" to sheet2!Z5="Audi A4") it works again too. thus far there is not a problem i am facing with.

However,

1- when i change a cell value on table in Sheet1, the function on Sheet2 doesn't trigger. (for example: Audi A4 is in Sheet1!A7 and i copy it to Sheet1!A12)

2- Other thing is when i replace the value in Sheet1!B7 (for example Sheet'A7 is Audi A4 and Sheet1!B7 is 40000, and i change 40000 to 30000 in Sheet1!B7) corresponding to Sheet1!A7, the VBA function in Sheet2 does not trigger.

What needs to be done to solve this problems? Thanks in advance.

My macro codes are:

Please Login or Register  to view this content.

Hi, sixthsense, thanks for response, i changed the code, but still same problem happens.

the revised code:

Please Login or Register  to view this content.