look up a part number on differnt tab. Return spacific colum based on

[pmw19800]

Hello All

I need a formula on TAB 03000501 to look up part number in Column c and then search TAB 03000507 and return whatever is in column B. when there is a match
Please see attached

Expected results highlighted in orange


thanks

Paul

[Special-K]

in E2
=IFERROR(INDEX(_03000507!B$2:B$1000,MATCH(C2,_03000507!C$2:C$1000,0),1),"MISSING")
and copy down the column