Help Using a Master Worksheet #VALUE! ERROR

Hello.

I am trying to use a master worksheet to use a basis for keeping track of all client info of when clients dropped off, when we received information, etc. and I am trying to use the other pages within the workbook for individual clients. I have put the master worksheet into a list format.

I'm trying to place a nested IF function on one of the sub pages right now, but I keep coming up with a value error.

I've looked at some websites for help, but they mention that you have to define names for the data you want to include in the nested IF function. I've tried this and I haven't succeeded.

This is what the function looks like now:

=IF(Compilation_Master[[#This Row],[Received]]>0,"have","need"),IF(Compilation_Master[[#This Row],[Entered]],"E","N")

Any thoughts to how I can get this function to work or if I have mistyped it?

Thanks for your help!

How would I upload? I guess I can upload it to Google Docs and share it, but I don't know how to do that and keep the formatting the same. Any thoughts?

Here is the attachment. Hope it works! I'm keeping my fingers crossed.

It's a dummy worksheet with the information and explanation of why I wanted the data in that particular way. If there is a better way to do this, I am open to suggestions.

Thanks again!

That's what I thought too, but I was hoping there would be a different way. Oh, well.

Thanks for your help.