Hi , need help to create a cross reference tool,
In Col. A, I want a drop down menu so you can pick the obsolete part#, that will populate col. B (description), then in Col C, I want to display a range of parts associated with the part# in Col. A , but in a second drop down menu. Once you select the part# in the 2nd drop down menu, I want to display the cross referenced part# to show up in Yellow
hope that makes sense, see attached excel file
thanks
Bookmarks