Hi,

I am using below formula but giving me value error.

IF(A3:A2198<>"",CHOOSECOLS(FILTER(LUX!A6:R1236,A3:A2198=LUX!C6:C1236),11,"")
Kindly can anyone rectify the code where it has gone wrong.