Function Lookup

[Heather]

=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

 

[Bob Phillips]

Try

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

 

[Heather]

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]

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