VBA user defined function (UDF)

Industry: Business
Description of excel work: Create a vba function that can be used in an excel workbook; call the UDF "EGlookup". This function will need to take a text value(column B) and a date value (column D) from one sheet, in another sheet find the text value (in column J) and then see if the date value falls between two dates (column F and G). If it does, then the UDF should return value in column E to the formula location.
Extra notes: =EGLookup(value in column B, value in column D, range to find column B in, two columns to find date in between)

I'm having trouble uploading an excel workbook, so please see if you can do this without a data set.