index match drag the formula again

[AYSHANA]

Good day to all

I have to two excel file

1. Antibody

2. Sample register

I’m using index match formula to get the comment section (V column) from antibody file to sample register file by searching number (I6). The formula its working but the problem is whenever I will enter a new data in the antibody file it will not reflect to the sample register file unless I will drag the formula again so it will reflect.

I was not able to solve why I have to drag it again.


cell I32 and cell I37 in known while the rest is new, if i drag the formula again it will work, but i dont want to drag each time if i have new data entery in the antibody file.

Kindly refer to the following

Sample Receiving Register 2024.xlsb
	I	J	K	L	M	N	O	P	Q	R	S	T
32	152											0
33	130
34	140
35	130
36	140
37	125											0
XMATCH

Cell Formulas
Range	Formula
T32:T37	T32	=IFERROR(INDEX('C:\Users\dts_user05\Desktop\AYE\abi\[Antibody Workup & Other Cases Database.xlsm] ABI Database'!$V$5:$V$20000,MATCH($I32,'C:\Users\dts_user05\Desktop\AYE\abi\[Antibody Workup & Other Cases Database.xlsm] ABI Database'!$H$5:$H$20000,0)),"")

 

[DanteAmor]

Try:

Click on the "Formulas" tab in the Excel ribbon. In the "Calculation" group, ensure that the calculation mode is set to "Automatic.

 

[AYSHANA]

It is set as automatic