I am trying to lookup criteria to the left of my usual vlookup, so thought I would give Index/Match a look. The formula only seems to return the reference cells in numeric order instead of looking at the unique item number I want it to use.

Here is the formula I have been using:

=INDEX('LW Dump'!$A$5:$A$500,MATCH('01.03.14 Fcst Export'!$B2,'01.03.14 Fcst Export'!$B$2:$B$500,0))

A5:A500 are what I want returned, but I want it to return the cell that corresponds with B2

Thanks!