Using an Index by Column Headings instead of Column Numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sean Bishop - 20 Nov 2006 00:45 GMT

I am using Excel 2000
Recently I was very kindly helped to to formulate an address from a linked
spreadsheet.
This worked well BUT the man who keeps the database that the spreadsheet is
linked to has a habit, if he has to do a lot of updating, of moving relevant
columns together. Apparently Access works on column headings/field names so
the location of a column in a table is irrelevant.
This means I have to check the linked spreadsheet to verify if I am still
using the correct column numbers.
I have looked at all the index formulas but I cannot seem to find one that
uses column names instead of column numbers.

QUESTION:
Is there a formula that I can use that looks at the column name ?

Thank you in advance for your help.

Sean Bishop

Reply to this Message

Debra Dalgleish - 20 Nov 2006 01:01 GMT

You can use the INDEX and MATCH functions, as shown here:

http://www.contextures.com/xlFunctions03.html

> I am using Excel 2000
> Recently I was very kindly helped to to formulate an address from a linked
[quoted text clipped - 14 lines]
>
> Sean Bishop

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Sean Bishop - 21 Nov 2006 21:38 GMT

Dear Debra,
Thank you for your answer.
It worked and has solved my problem.
I did however notice that if the cell was formatted as TEXT it did not work
but when formatted as GENERAL it did, but this seems to be the case with a
lot of formulas.
Again, thank you.

Sean Bishop

> You can use the INDEX and MATCH functions, as shown here:
>
[quoted text clipped - 18 lines]
> >
> > Sean Bishop

Reply to this Message

Rate this thread: