Need formula for highlighted field

[aparvez007]

Hi All,

Need your help to get required field from Data entry sheet to Output Print.




Regards,
paVi

 

[Khalid NGO]

Hi Pavi,

Try this in B16 and copy down and across:

=IFERROR(INDEX(Table1,MATCH($G$6,Table1[Ref. No],0)+ROW(A1)-1,MATCH(B$15,Table1[#Headers],0)),0)

Regards,

 

[aparvez007]

Thanks.