Populate multiple rows of data using a combination of... (IF ROWS INDEX SMALL)

[steveh1873]

Dear All,

The inserted picture displays two database examples from two separate worksheets within the full spreadsheet. (they are all pasted together for ease). It also shows where i'd like the data drawn from the databases populated.

I am looking for assistance on the following:

I'd like to automatically populate cells A7:J7 and the cells below (where applicable) with data from two separate worksheets, when the Cell B5>0 & where the 'Company' from the 'Customer Records' matches Cell B1.

I'd like Cells A7:F7 populated from the Worksheet 'Customer Records' and Cells G7:J7 from the Worksheet 'Complaint Records'

I'm sure this is completed using a combo of IF, ROWS, INDEX and SMALL, but can't seem to piece the formula together myself

Any help is greatly appreciated

Kind Regards,

Steve