Lookups Tables

I have attached a spreadsheet with two lists of data. I want to use a lookup table or something useful to match mulitple data.

It's hard to explain, but I will try. I want to use lookup table to add a entry to the result field if it matches the ref, start date & end date with a adjustment number from that lookup table.

Example

First List

Ref Start Date End Date Result
100046684 03/04/2006 25/03/2007 (it would look at the lookup table and enter a 4 for adj no)

Lookup Table

Ref Start Date End Date Adj No
100046684 03/04/2006 25/03/2007 4

I hope you understand what I am trying to do.

Thanks

Nick