I'm trying to create some formulas and conditions to pull information from one workbook to another; however, I keep running into #Value! errors. I'm wondering if it is a reference issue. I say this because one piece of information I am referencing is my company's seed variety type, or a common identifier that our salesmen refer to each individual product. For instance, one product number is "39ry43". Could the issue be that excel is getting confused when it sees numbers and text that are combined? Thoughts/suggestions?