Hi I cant seem to get my head round this, im trying to lookup 2 fields in a xls file with 2 criteria's in my dlookup,
this is what my code looks like for lookup of 1 field;
=Dlookup("morning","JulyLinked',"day=" & day(date()))
this works for looking up the day field in the linked table...