My formula is looking up a temporary file when I do not want it to

[jbeets]

Hi,
This might be a ridiculous question but I have never had a formula do this to me. I have a workbook that has an IF(AND statement that pulls the results from another tab however when I try and enter the formula a "Update Values- 'Lists'" box pops up which seems like it wants me to select a file to provide the results.

This is an example of the formula - Its just a piece of it because the formula just repeats but is really long.

=IF(AND(E34="WelcomeBags",F34="FoldMaps"),Lists!$B$2,IF(AND(E34="WelcomeBags",F34="Collate5"),Lists!$B$3,IF(AND(E34="Collate",F34="Collate"),‘Lists’!$B$7,IF(AND(E34="Collate",F34="Sales Kits"),‘Lists’!$B$8,

Thank you for any help you can give me!

JBeets

[sktneer]

Use Lists!$B$7 and Lists!$B$8 instead of 'Lists'!$B$7 and 'Lists'!$B$8.

[jbeets]

Thank you sktneer, one of those so simple right there in your face mistakes! Thank you for helping me so quickly!

Jbeets

[sktneer]

You're welcome.

If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.