Search results

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...

Hi, I m looking to import data from an excel file but from different worksheets on the same excel file. I can import the data from a specific worksheet, but I would like to know how to lookup a different worksheet on the same xls document. thanks