Formula to Return Cell Value based on Row and Column

[Hobolord]

Hello!

I am using excel 2010 on Windows 7.

I am trying to figure out a formula to return the value of a cell that is in the same column as criteria x and the same row as criteria y. For example:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Ford[/TD]
[TD]Dodge[/TD]
[TD]Chevy[/TD]
[/TR]
[TR]
[TD]2009[/TD]
[TD]9[/TD]
[TD]3[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]2010[/TD]
[TD]4[/TD]
[TD]7[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2011[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]

I would want my formula to be able to pick the count of 2010 Dodges (7).

The formula that I have now is:

=VLOOKUP($C$6,'HFM DATA'!A3:N500,MATCH($C$9,'HFM DATA'!A3:N500,0),FALSE)

Where C6 is the first criteria and C9 is the second criteria. But it is returning a #NA, and there definitely is a number there.

Does anyone know what I'm doing wrong, or even have a better solution?

Thanks for your time!

 

[Hobolord]

I updated the formula with 1's to no avail. Any other ideas?

 

[Caribeiro77]

Sorry but i don't know what else can i do....to achieve your need's i would need to see screenshots of your both sheets
if you want you can use photobucket to upload them.
If you can't put that information here, i can't hel you no more.
Just wait and see if somebody else see's your thread and manage to help you..

 

[Hobolord]

I'm at work and sadly photo sharing sites are blocked. Thank you for your time and trying to help me, though!

 

[Hobolord]

I figured it out! The formula that I got to work is:

=VLOOKUP($C$9,'HFM DATA'!A3:N500,MATCH($C$6,'HFM DATA'!$A$3:$N$3),0)