Hi there,

I am working with this formula:
=IF('Data Entry'!B$4="Training",AND(IF('Data Entry'!C$4="January",('Data Entry'!E$4),(" "))))
If true, I would like contents of cell "Data Entry'!E$4' displayed, not the words "True"
If false, I would like the cell to remain blank. From my research, it looks like I can't. Thought I would ask here to confirm.
I am trying to setup a spreadsheet where you select a category (B4) and month,(C4) then the info in E4 gets transferred to the correct month which is a difference sheet.

Thanks!