**Kit Sheet**
**Excel 2010**
<tbody>

[TD="align: center"]1[/TD]

[TD="align: center"]Kit #[/TD]

[TD="align: center"]Part #[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]4060001003[/TD]

[TD="align: center"]2801002002[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4060001003[/TD]

[TD="align: center"]60042544[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]4060001203[/TD]

[TD="align: center"]2801002202[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]4060001203[/TD]

[TD="align: center"]60042544[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]4060001302[/TD]

[TD="align: center"]2801002301[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]4060001302[/TD]

[TD="align: center"]60042544[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]8660011001[/TD]

[TD="align: center"]90258[/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]8660011001[/TD]

[TD="align: center"]8308000601[/TD]

</tbody>

**Kit**

LookUp Sheet
IN the D2 Cell:

=IFERROR(INDEX(Kit!$A$2:$A$9,MATCH(LookUp!A2,Kit!$B$2:$B$9,0)),"")

**Excel 2010**
| A | B | C | D | E |
---|

Item Number | Supplier 1 Active | Supplier 2 Active | Kit # | Kit Part # | |

8308000601 | 8308000601 | 8660011001 | | | |

4060001003 | | | | | |

4060001003 | | | | | |

4060001203 | | | | | |

4060001003 | | | | | |

4060001302 | | | | | |

4060001003 | | | | | |

8660011001 | | | | | |

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>

</thead><tbody>

[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]#N/A[/TD]

[TD="align: right"]#N/A[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]2801002002[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]60042544[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]2801002202[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]60042544[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]2801002301[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]60042544[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]90258[/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: right"][/TD]

</tbody>

**LookUp**

If you have other fields & a # to match you can apply it across all your columns.