tyndale2045
08-07-2008, 02:09 PM
I have a UDF called Breed_Standard that I am trying to use. My goal is to use range names with the VLOOKUP function (so as to avoid making long and confusing IF formulas). Check out the attached workbook, and you'll see what I mean.
My problem is this: It appears that Excel is enclosing the result of the UDF in quotation marks. The quotes prevent Excel from recognizing said result as a range name. Thus, the formula fails.
What to do?
Any help will be greatly appreciated.
Jim
[Later edit: Woops, I now see that the example I've sent does not actually include the long IF formula in the cell with the second comment. If you want to see the giant IF statement, though, let me know. I'm sure you'll find it as boring and confusing as I do.]
My problem is this: It appears that Excel is enclosing the result of the UDF in quotation marks. The quotes prevent Excel from recognizing said result as a range name. Thus, the formula fails.
What to do?
Any help will be greatly appreciated.
Jim
[Later edit: Woops, I now see that the example I've sent does not actually include the long IF formula in the cell with the second comment. If you want to see the giant IF statement, though, let me know. I'm sure you'll find it as boring and confusing as I do.]