This code will display all the models in the inventory list on sheet1, for a size entered by the user on sheet1, in the search cell on sheet1 cell F4. The list of all the models in the inventory on sheet1 that are in the size entered in F4, will be listed on sheet2.
This is a filtered lookup and not a true matrix operation but it may fit for what you are doing. In the future you needed to provide a sample of the data and the solution for us to be certain. So I guessed. JSW
Sub myFind()
'Find by size
With Worksheets("Stock")
.AutoFilterMode = False
.Range("A1").AutoFilter
.Range("A1").AutoFilter Field:=1, Criteria1:=Range("F4"), VisibleDropDown:=False
.UsedRange.SpecialCells(xlCellTypeVisible).Copy _
Destination:=Sheets("Found").Cells(1, 1)
Application.CutCopyMode = False
.AutoFilterMode = False
End With
Sheets("Found").Select
Range("A1").Select
End Sub