=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

Try

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

--

HTH

Bob

"Heather" wrote in message
...
=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

It worked once I added

IF(ISNUMBER(MATCH("COB",Routing_Count_04072010!A:A ,0)),INDEX(Routing_Count_04072010!B:B,MATCH("COB", Routing_Count_04072010!A:A,0)),0)


Thanks
"Bob Phillips" wrote:

Try

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

--

HTH

Bob

"Heather" wrote in message
...
=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



.

Silly omission on my part, glad you were able to work with it.

--

HTH

Bob

"Heather" wrote in message
...
It worked once I added

IF(ISNUMBER(MATCH("COB",Routing_Count_04072010!A:A ,0)),INDEX(Routing_Count_04072010!B:B,MATCH("COB", Routing_Count_04072010!A:A,0)),0)


Thanks
"Bob Phillips" wrote:

Try

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

--

HTH

Bob

"Heather" wrote in message
...
=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



.