Excel 2007: Finding Column Position


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
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top