Column = used in templates

**Oneski** · 09-23-2011, 10:34 AM

I have a templete that uses column=nameA column=nameB column=nameC. What I want to do is have a column=nameA or nameB, but I can't seem to get the correct syntax. I have tried column=(nameA or nameB) and column=OR(nameA,nameB)

**pmalen** · 09-24-2011, 10:20 PM

Are you trying to use the COLUMN function in excel to do this? That function returns a numeric value of the column that the formula references. Might be easier to create a range name for the entire column.

**teylyn** · 09-24-2011, 10:39 PM

Oneski,

I have a templete that uses column=nameA column=nameB column=nameC.

Uses? Where? In a formula? In VBA?

Post a workbook and explain in context.

**Oneski** · 09-26-2011, 02:44 PM

Originally Posted by teylyn

Oneski,

Uses? Where? In a formula? In VBA?

Post a workbook and explain in context.

I have a templete file that is used to populate a parts list. It uses column=Quantity. Like the following:
"
Item #" " Qty " " U/M" Reference Designators "Cage Code/Sub Cage Column=Quantity Column=Designator Column=CAGE NO. Column=PART NUMBER Column=Description Column=MFG ID Column=Manufacturer #1 Column=VIDNUM
What I want to do is use the OR function so one column could equal one of two things. See attached

**pmalen** · 09-26-2011, 03:32 PM

Don't see the attachment.

**Oneski** · 09-26-2011, 05:26 PM

Attachment

**teylyn** · 09-26-2011, 05:59 PM

I don't understand. You have a table with three rows, the two top rows contain text.

Just type the text that you want to appear. There's no calculation going on here, anyway, so what would you want to use an OR function for?

This needs a lot more explanation.