Look up phone number by criteria

[brandon_clyde]

Ok so I have an excel spreadsheet setup.
A B C D
State DEC Name Phone Number


What I am trying to do is search for a number under column B and then return the Phone Number in column D that corresponds on the same row.

=INDEX($B$2:$B$322, MATCH(E2,$D$2:$D$322,0), MATCH($F$2,$D$2:$D$322,0))


This does not work.

 

[brandon_clyde]

#N/A

 

[brandon_clyde]

A value is not available with the Formula or Function.

 

[Fluff]

In that case Excel cannot find the value.
In an unused cell use
=E2=B5
changing the B5 to look at the cell that should match E2, what does the formula return?