Pull specific info for a range of cells

So the problem I have is I am looking for a different / better way to do this. Currently I am doing this -
=IF('[CROWS-Master Input.xlsx]CROWS-Master Input'!$B2=C3,'[CROWS-Master Input.xlsx]CROWS-Master Input'!$H2,"")

A Couple things.
1. The above is in 9 different cells and the last cell ref. just goes from H2, H3, etc for a total of 9 entries.
2. C3 is a Company name, H3, H4, etc. is a serial number.
3. This fills out 1 to 9 blocks on a form and I could have a max of 10 different forms ( for different companies) all with this formula in 9 cells (on each form)
4. If I keep it this way, on my master data sheet I must give each different company 9 rows even if Company A only has 3 Serial numbers, meaning I would have to have 90 rows total to account for the max possible entries. I never need that many.

Real life is I may have 4 different companies and 2 may need all 9 serial number entries and the other 2 may only have 3 ea.
Based on the above, I would need to have to have 36 rows/cells to make this work.

So...I want to be able to just use the min cells for the current data I have which in my example would be 24 cells vs. 36. All the info in the datasheet would just be entered in line, no blank cells. I want excel to look at all the Serial numbers and only put the serial number(s) that are connected to a specific company for that form and enter the information either in 1 cell on the form (easiest way I suppose) or only put 1 (different) Serial number into each of a possible 9 different cells , on each of 4 different forms (based on my example above).

Hope this make sense and thanks for any help anyone can provide.

balucanb, thank you for editing your post title.

Also, maybe posting a sample workbook with some representative samples AND some expected results will help after you adjust the post title. Thanks.
If you're having trouble posting a sample workbook using the attachment symbol, it doesn't work. So click on the "go advanced" under this window, then midway down it "manage attachments" click that then browse to the sample, hit upload, ok to close the window then post.