Hey Everyone,
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!
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!