Thread: Help Using a Master Worksheet #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

It is not necessary to create "defined names" (which I take to mean named ranges) to use the IF function.

However, in order for us to provide a precise answer, it would be best if you uploaded a sample workbook that meets the following criteria:

1. It EXACTLY duplicates the structure of your real workbook, AND
2. It contain representative but non-sensitive dummy data, AND
3. It manually illustrates a couple of expected results for clarity

Click on GO ADVANCED and use the paperclip icon to attach a file.

I think your criteria are conflicting, I can't reconcile them to all exist together. I guess you have to go in this order:

1) Does the item exist? If not then answer = "Need"

If it exists, = "Have" isn't a useful response because of the following criteria.

2) If exists, has it been reconciled? If so, then answer = "Reconciled"
3) If not reconciled, has it been entered? Is so then answer = "Entered"
4) If not entered, then answer = "Not Entered"

So the only codes I see working are:

"Need"
"Not Entered" or "Have - not entered"
"Not Reconciled" or "Entered, not reconciled"
"Reconciled"

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.