index match

[jw01]

Hello

Having some issue with the index, match formula, not sure why it's causing some problems. i have attached a sample workbook. the formula is as follows:

{=INDEX(mySource,MATCH(1,IF($S$5:$S$160=E$8,IF($T$5:$T$160=$C$5,IF($U$4:$U$160=$C9,1,""))),0))}

getting the N/A error.

Basically, trying to match, by period i.e. P1, P2..P12, and then Region name, i.e. US Northeast, US SOutheast etc and then by criteria i.e. total revenue, to get the value.

I have highlighted the cell in red. pls help!

[ConneXionLost]

How about this:

Please Login or Register  to view this content.

Cheers,

[jw01]

Hey buddy

that is giving me 337, which is fine, but my search is for US Northeast, which should be 126.

Not sure, why it's searching for refercning the wrong region? ur thoughts?

[ConneXionLost]

Seems to work just fine in your example.