Use a Defined Name formula, depending on a cell value

Your request is pretty vague, but I am guessing that a VBA solution using Select Case may be what you need. Please supply a sample worksheet with an explanation of what you need to happen (expected results) and I am sure that one of our experienced volunteers will lead you to a proper solution.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

More detail about the named formula? Exactly what you have could be accomplished by =CONCATENATE(B9,"_Formula") and not use the named formula.

A lookup table + function is often a good replacement for multiple nested ifs. https://support.office.com/en-us/art...8-93a18ad188a1 I think a lot depends on what that named formula is really doing.

Was typing and copying while MrShorty posted.

Something like this?

Press the F3 function key and paste named formulas. Here it is in columns H:I.

Then this formula in C8 and filled down.

Formula:

Please Login or Register  to view this content.

	B	C	D	E	F	G	H	I
1							Ash	="Ash_Formula"
2	Mahogany	when ony 3 categories		Mahogany_Formula			Birch	="Birch_Formula"
3	Walnut			Walnut_Formula			Mahogany	="Mahogany_Formula"
4	Oak			Oak_Formula			Maple	="Maple_Formula"
5							Oak	="Oak_Formula"
6				What to expect			Walnut	="Walnut_Formula"
7
8	Ash	Ash_Formula	In C8: =IFERROR(SUBSTITUTE(SUBSTITUTE(VLOOKUP(B8,$H$1:$J$6,2,FALSE),"""",""),"=",""),"")
9	Birch	Birch_Formula
10	Maple	Maple_Formula
11	Cherry
12	Pine
13	Spruce
14	Cedar
15	Fir
16	Larch
17	Plywood
18	Fiberboard
19	ChipBoard

Thank you for your help MrShorty and FlameRetired.

What I need is to call the named formula, so it can do the needed operation.
the "wood_formula" text is just an example of data contained in the named formula.

Thank you again.

May I ask why VBA is to be avoided? It will be the simplest solution, I think, though you could also do it in a less flexible way with an XLM function. Either way the file would need to be saved in macro-enabled format.