Hi can someone please help me here,
I have 2 sheets involved
I wish to fill cells with the formula to get cell data
formula to go in to A2 Book1 Sheet1

Book1 Sheet1

Fields, Sheet1
required cell to return is Column 6

I start with blank column in Book1 sheet1

data starting in B2 with a dynamic range each day
must lookup B2+C2 in Book1 Sheet1
must match
Fields Sheet1 A2+B2
and return the data in column 6

Hope this makes sense to someone there

Regards
Graham