Hi Rylo,

Thank you for your response.

For the criteria "Name":
it can appear in colum D, F, H, J, L, N

For the criteria "NRIC",
it can appear in column E, I, K, M, O

I would also need the results to show their header, that is for e.g:

Name criteria = Wee Oon Phing - there are a total of 3 results

Then the returned data should be
1) Wee Oon Phing + {header} = Witness + Column A
2) Wee Oon Phing + {header} = Witness + Column A
3) Wee Oon Phing + {header} = Witness + Column A

Thank you.