Wow, quick replies. Thanks.
@Product is the Table cell on the invoice that I want to lookup on the Product sheet table.

The data in the lookup column doesn't have any gaps, the gaps are on the other columns.

I've attached my excel file as I'm struggling to explain it I think! This is what I'm after: http://www.excel-university.com/sele...le-attributes/

Invoice test.xls