A B C D
1 Toyota Chev Buick
2 xxxyz 500 100
3 trxxx 300
4 yyzsz 200

I have a sample of the following spreadsheet. I want to extract out only
the data that matches columns B-D and the number. In other words I want to
make a list that matches a car with the data and only lists if it has data
assoicated with it.
For ex. give me Toyota and xxxyz but I don't wont Toyota and trxxx since it
has no data associated with it.

Thanks in advance.