Need help with Index Match formula

I Need help with Index Match formula. In column A I have a list of ID's. In column B I have a list of C #'s. In Column C I have the formula IN Column E I have alternate ID's. What I want to do is identity all those ID that are listed in the Alternate ID column. If the ID in A is listed in E then give me the data from Column B. otherwise leave blank.

Hi,
please try this:

In C2 and down:

=IF(ISNUMBER(MATCH(A2,E:E,0)),B2,"")

If you are trying to get the C# relative to col E try
=IFERROR(INDEX($B$2:$B$633,MATCH(E2,$A$2:$A$633,0)),"")

Thank you for providing this formula =IFERROR(INDEX($B$2:$B$633,MATCH(E2,$A$2:$A$633,0)),"").

It appears to work in most situations but for C5 we should be returning the same value as we see in C 4 & 5 as the value in A 4,5,6 is the same "BJY000493122" but for C6 we get no value.

THoughts on the fix?

But "BJY000493122" does not exist in col E.
So I don't understand what you are trying to do. Have you tried the formula from belinda200?

You are correct "BJY000493122" is not in the Alt ID column E so no value in C6 is correct. Do you know how to not get the values returned in C4 & C5. I tried the formula from Belinda200 and it does not work.

What values would you expect in C4, C5 & why?

For C4, C5, C6 should all be blank like C6 is with this formula =IFERROR(INDEX($B$2:$B$633,MATCH(E2,$A$2:$A$633,0)),""). "BJY000493122" is not in the Alt ID Column but with this formula C4 and C5 populate but C6 does not. Attached updated sheet with this formula =IFERROR(INDEX($B$2:$B$633,MATCH(E2,$A$2:$A$633,0)),"").

What is wrong with belinda's formula?

You are correct. My bad. Belinda's formula is working correctly. The other one is producing false positives. Thank you

Glad it's sorted & thanks for the feedback.