Searching one table to report values

Hello,

anyone who can help? I have the following

two tables, I want to search the Table A for certain values and report them in Table B

Table A

A B C D
5/5/11 Business Fuel 56
5/5/11 Sales 120
6/5/11 Sales 34
8/5/11 Sales 26


Table B

H I J
Date Sales Fuel
5/5/11
6/5/11
7/5/11

Example: Where the date in column H is the same in colum A AND where the value in colum B is 'Sales', I want Coumn I to report the value in column D (120).

Another example: where the date in column H is the same as in column A AND wwhere the value in Column C is 'Fuel', I want Column J to report the value in colum D (56)

I want Table B to look like the following

H I J
Date Sales Fuel
5/5/11 120 56
6/5/11 34
7/5/11
8/5/11 26

Can anyone help? Thanks!