Function Lookup

  • Thread starter Thread starter Heather
  • Start date Start date
H

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
 
Try

=IF(ISNUMBER(MATCH("COB",Routing_Count_04072010!A:A,0)),INDEX(B:B,MATCH("COB",Routing_Count_04072010!A:A,0)),0)
 
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
 
Back
Top