I think you want something like this:

=IF(AND('Master Sheet'!G4=I$2,'Master Sheet'!G4<=J$2),'Master Sheet'!
G4,IF(AND('Master Sheet'!I4=I$2,'Master Sheet'!I4<=J$2),'Master
Sheet'!I4,""))

Hope this helps.

Pete

On Dec 23, 6:46*pm, fyrefox wrote:
I have a workbook with date and description data. I have tried multiple
formulas like this one and get #values or name...

=IF(('Master Sheet'!G4=I$2,'Master Sheet'!G4<=J$2),'Master
Sheet'!G4,"")*IF(('Master Sheet'!I4=I$2,'Master Sheet'!I4<=J$2),'Master
Sheet'!I4,"")

MS G-4 and MS I-4 are dates I-2 is the lower date and J-2 is the higher date.

"To make it simple I want the items due in Jan. to show up and all other
data to be blank" This information is on a second worksheet in the same
workbook.

Thanks