Searching 3 ranges/columns of cells

I am trying to search three columns on a worksheet, that contain a range of customers, product names and the amount of that product sold to the to the customer.

On a separate worksheet I have created a table, which I hope will show the customer, the product and the amount sold.

So basically I need either a formula or piece of code that can match the customer and product, along with the amount sold and display it in one table.

The data is by nature not kept in alpha or numerical order and my problem lies in being able to search through each row and extrapolate the necessary figure.

Any help would be greatly appreciated.

A

use Vlookup()

E.g.

=Vlookup(A2,'Sheet2'!A:D,Columns($A$1:B$1,0),FALSE) copied across and down.

where A2 contains customer to look up

Sheet2!A:D contains your database...