=IF(Routing_Count_04072010!A:A = "COB",Routing_Count_04072010!B:B,0)

I can use the above as long as the fields do not change and it works
perfectly. When the field moved on the new sheet. I still get a return of
True and a value of 23. Which is correct; however, it show final result as 0.

Is there another function I should be using.

Basic Idea is if it finds the value of COB in Column A. It will return the
Amount listed in Column B from the same Row.

Thanks