Index Match formula not giving correct answers -- I think I'm missing a piece of the formula
<p>I'm trying to use Index Match to Compare a numeric code in Column B with anything that's a match in Column E, and if it's a match -- pull the info from same line in Column D and place it in Column A same line as Column B code used to match. I've never done a "results from a 3rd column" formula so I have no doubt I'm missing something.</p>

<p><a href="http://i.stack.imgur.com/KvrdK.jpg" rel="nofollow">Example of Spreadsheet columns</a></p>

<p>For example:  B2 is A01.01 -- it matches E2, so I'd like to have it pull D2 which is 002.0 into A2.</p>

<p>B4 is A35. It matches E6, so I'd like to have it pull D6 which is 037 into B4.</p>

<p>If no match, it can either leave it blank or show #N/A, I don't mind which.</p>

<p>The columns are NOT the same -- I have B1:B3717, while D &amp; E are both 1:3809.</p>

<p>MY problem is I've tried every trick I know with Index Match and I think I'm missing something -- I've tried doing this with the results to an A column as well as the F column (I know some go right to left, some left to right) -- but my biggest problem is (a) getting the system to search the entire list in column E, AND (b) getting the results to pull correctly from Column D to Column A (I keep getting the "last" one until it pulls a new one?</p>

<p>The formula that at least pulls something is =INDEX(D2:D3809,MATCH(B2,E2:E3809)) -- BUT, it does NOT include the 0 for exact match (every time I add the zero to indicate an exact match ALL I get are #N/A. BUT with the formula NOT indicating exact match, I'm getting a few correct ONLY because the line to the right of the B item matches. With the formula listed, I'm getting results lines as follows:
2 - 002.0 correct
3 - 011.9 correct
4 - 012.80 correct
5 - N/A  incorrect -- A35 should match E6 and give a result of 037
6 - 037 -- incorrect, no match so no result should be listed this is previous result duplicate
7 - 038.10 which is correct
8 - 038.43 which is correct - same line
I seem to be getting #N/A's on some lines that don't match, but per #6 above, that shouldn't have had a result either.</p>

<p>Again, I've gone through multiple answers and tried what I could that seemed to be similar, as well as the Top Mistakes when Using INDEX MATCH. </p>

<p>Any guidance would be appreciated.</p>

<p>Michelle J.</p>