Match datafigures from summary report with detailed data sheet

I have a summary report no with sequence no which need to match with datasheet of a partiular column of summary report sheet column
See annexed for colums in yellow

Try the below in cell N2 and copy down:

Formula:

Please Login or Register  to view this content.

BSB

Working a charm

thank you for your help