index match

[bluepenink]

Hello

Struggling with my index match formula. In need of some assistance. here is my formula:

=INDEX(Table3,MATCH($C7,'Send vs SWAT 2011'!$C:$C,0),MATCH(G$6,'Send vs SWAT 2011'!$I$6:$DD$219,0),)

it's giving me a N/A error.

Table 3 i defined as $C$6:$DD$219 (where all my data is stored)
C7 = Person's name
C:C = where person's name is found on other worksheet

G6 = P1W1 (or period im looking to get figured for)
column I$6 on the other worksheet contains P1W1, P1W2 etc
I6:DD219 is where all the data is.

any suggestions? pls and thx u!

 

[Andrew Poulsom]

If your table is in columns C:DD, why are you looking for the heading in columns I:DD?

 

[bluepenink]

im trying to match

Person's name, with the a particular week (i.e. P1W1) to obtain their weekly sold $ amount.

=INDEX(Table3,MATCH($C7,INDEX(Table3,,1),0),MATCH(G6,INDEX(Table3,1,6),0))

I tried this but still not luck

where table 3 = Send vs SWAT 2011'!$C$6:$DD$219

match (C7 = Person's name (Mike Jones), in column 1 aka C where it contains their name)

and then

match (G6 = P1W1, in table 3, in row 1 on column 6.....column 6 = cell (I) where the P1W1 portion starts.


thxs..im sure im making this way to complicated thats why it's messing up

 

[Andrew Poulsom]

Try:

=INDEX(Table3,MATCH($C7,INDEX(Table3,0,1),0),MATCH(G6,INDEX(Table3,1,0),0))

 

[bluepenink]

that is showing me a 0, similar to what i was getting.

basically, here is the layout in my workbook where i need the data to come from aka table3


C7 = Person's name
P1W1 $ value for person in C7 = $I$8

 

[Andrew Poulsom]

The formula I posted works for me. Can you post a small but representative sample of your data?