LookUp/Match/Index Not Working

[mulholm]

I have the following formula:

=(LOOKUP(B3,January!D:D,January!J:J))

B3 = "Agent 3"

The Table i am trying to look form is the following:

A B C D E F G H I J K Location CSM Manager Agent Conformance % Adherence % Inbound Calls Ave Inb Talk Ave Inb Hold Avg Inb Wrap Inb AHT X X X Agent 1 99.75% 97.0% 7,740 360 91 165 525 X X X Agent 2 104.26% 99.7% 68 482 116 208 690 X X X Agent 3 100.32% 97.8% 841 242 38 129 371 <tbody> </tbody>

<tbody>
</tbody>

The formula should return "129" as this is what "Agent 3" Avg Inb Wrap is, however when i run the formula it just returns "Avg Inb Wrap".

Any ideas how this is?

 

[SpillerBD]

Managed to get it.

Whoever made the spreadsheet has a double space inbetween agent and1

At least it wasn't a non-breaking space