Index( match()) in excel

Wanted to map the external id of the items to corresponding BoMs of the item.

• This was done using the formula: =INDEX($D:$D, MATCH($C2, $E:$E, 0))
• [MATCH($C2, $E:$E, 0) finds the row in Column E where the value of Column C in the current row (C2) appears.
• INDEX($D:$D, [that row]) returns the value from Column D in the matching row.
• The 0 in MATCH indicates an exact match.]