Hi,

I couldn't see any #N/A results on your workbook. However rather than using functions to try and extract records like this you should be using Data Filtering. Either Data Filter on the list itself or use Data Filter Advanced to extract a separate list based on your G2 criteria.

Rgds