D
David Lipetz
Is there a formula that can look at a row of labels and return the columnar
position of a designated value?
For instance:
Row A: Apples Oranges Pears Peaches
How can I programmatically determine the column number for Pears?
The end result is I am trying to do a VLOOKUP but the column number may be
dynamic though the label will always be the same.
Thanks,
David
position of a designated value?
For instance:
Row A: Apples Oranges Pears Peaches
How can I programmatically determine the column number for Pears?
The end result is I am trying to do a VLOOKUP but the column number may be
dynamic though the label will always be the same.
Thanks,
David