I am trying to see if there is a way to select a part number in a field and have that number populate in a separate field that I can use for other formulas. For example. I have a list of 161 part numbers in column E8 to E168. The are all 8 characters in length (not sure if that matters). I would like to be able to select one of the part numbers in that list and have the same number auto populate in cell E5. I was thinking of adding a check button to the left of the part number and writing a formula in cell E5 that would populate if the box was checked. Ideally it would be great if the part number was like a hyperlink, and if you selected it that number would appear in cell E5.

See attached excel.
populate field.xlsx

Any help would be appreciated.

Thanks.