Hi,

I want to make a formula probably using Vlookup, but not necessarily, that
uses two reference cells, i.e a date and a line number, looks at another
table matches the correct values to the required reference cells and returns
some other required data.



Line Date Required Field
A 01/06/2006 1
B 01/06/2006 2
C 01/06/2006 3
A 02/06/2006 4
B 02/06/2006 5
C 02/06/2006 6


i.e I want the required field to be returned when I stipulate that I am
looking for Line "B" and Date"2/6/06" and returns the number "5"

This is probably very easy but I'm afraid I just dont know how to do it.

Many Thanks,
P