Using 2 If Statements and searching the entire array

[afriedman]

Hi,
I am trying to use this formula
=IF($C$5:$C$72=G6,IF($B$5:$B$72=$H$5,D:D))

to return for me column H

In essance, what I am saying is
If within column C, I find Cell G6 AND within column B, I find Cell H5, Then return for me the associated number in Column D.

Currently, the way I am doing it, its only searching the row not the entire column. Anyone have any idea why thats happening and how I can make it work the way want it to?

(I have attached a file as an example and highlighted the cell's to show where there is a problem)

Thanks!