Please help me with a search function for a column. Given data in the
Level and Part columns below, I am trying to populate the Parent
column with the parent part number for each Part in a row. The
parent/child relationship is designated by the Level column entry,
where, for example, all of the Level 2 parts under a given Level 1
part have that Level 1 part as a parent. With nested IF functions, I
can easily march down the data as long as the Level number is
increasing or the Level returns to a value of 1. But as shown by the
"???" in the Parent column below, I do not have a way to easily and
systematically note that the parent for the Level 2 Part 090-806-00 is
really the first Level 1 part above that, Part 032-263-00. There is no
way to know ahead of time how many part of levels might be between a
part and its parent. Any suggestions?


Parent Level Part
(Top Level) 0 032-102-00
032-102-00 1 032-263-00
032-263-00 2 C
032-263-00 2 033-151-00
033-151-00 3 28D33151
??? 2 090-806-00
??? 2 091-449-00
??? 2 091-965-00
??? 2 091-966-00
??? 2 090-221-00
??? 2 470-163-13
??? 2 470-023-67
??? 2 470-207-49
??? 2 28C32263
032-102-00 1 094-018-00