Searching a database and listing inventory on another sheet

**oneillgirl808** · 04-05-2013, 03:41 PM

Hi Everyone,

This is my first post.

I would like to know how I would be able to formulate a cell that would give me the result(s) of inventory for a particular company.

See the attached workbook for my example.

Not sure it can be done.

I'd appreciate it!

Example_ExcelForum.xlsx

**Tony Valko** · 04-05-2013, 03:52 PM

Try this...

Enter this formula On Sheet1 in cell B2:

=IF(COLUMNS($B2:B2)>COUNTIF(Sheet2!$A:$A,$A2),"",INDEX(Sheet2!$B:$B,MATCH($A2,Sheet2!$A:$A,0)+COLUMNS($B2:B2)-1))

Copy down to B5 then across until you get a column full of blanks.