Hi All

Being an excel novice I might be going at this the wrong way but...

I am trying to look up 2 values from sheet one and find the answer on sheet
2 but can't work it out.

Find value (date)&(team) from sheet1 and lookup the result on sheet 2 (F2)

E.G look for date 13/8/05 and team Arsenal from sheet 1 on sheet 2 and
display result in column 6 (F2) on sheet 2

Sheet1
Date = i.e. A1 13/08/2005
Team = i.e. A2 "Arsenal"

Sheet 2
DATE HOME AWAY score h score a h result
a result = column headings
A2 B2 C2 D2 E2
F2 G2
13/08/05 Arsenal Bolton 1 0
HW AL

Anyone got any ideas?

Tried VLOOKUP but I can only get it to look for one condition i.e. date I
can't do both!

Any help, pointers greatly appreciated

Paul T