Finding a data in a chart

  • Thread starter Thread starter Dano
  • Start date Start date
D

Dano

I am sure this is in the archives but I can't it for the life of me.
I apologize for the redundancy in advance.

I have a simple problem:

I have a table of data
Names are in Column A
Different attributes are in Row 1

Usually I would use VLOOKUP to find what I am looking for.
In this case the column location of specific attributes change every
so often in the Table I import to excel.

For example Height will be in Row F one day and G the next.

I need a way to locate data using the name and attribute.

I am sure there is a very simple function or combination of functions
that archives this but I cant firgure it out.

I am working in excel 2003.

Thanks so much,

Dan
 
Assuming your data headings are in B1:M1, then you could use this to
locate where the word "Height" is:

=MATCH("Height",B$1:M$1,0)+1

This will return the column number where the match is found. You can
use this in conjunction with VLOOKUP to retrieve data from a
particular column of your table.

Hope this helps.

Pete
 
Assuming your data headings are in B1:M1, then you could use this to
locate where the word "Height" is:

=MATCH("Height",B$1:M$1,0)+1

This will return the column number where the match is found. You can
use this in conjunction with VLOOKUP to retrieve data from a
particular column of your table.

Hope this helps.

Pete
Click to expand...

Thanks so much.
 
Back
Top