If function

Hi all,

I am currently trying to setup a system that the user fills out information on one sheet, such as the suppliers name in A1 and the product and price in B1 and C1. I then want to have all the information in cell B1 and C1 go to the invoice (separate sheet) matching the name of the supplier in A1.

The problem I am having, is I am searching through over 100 names in column A and maybe returning results of 5 matching.

I am currently using an if statement that seems to work but everytime the statement is false it returns a blank row.

What I am wondering is if it is possible to create an if statement or any other kind of function to search a group of cells and return the true results in order and void the false results?

Thanks in advance for any assistance you can provide.

Thanks,

The VLOOKUP seems to work for what I want, but it only displays the first true result not the other 4 true. anyway to fix this?