Search for value and based on the answer return a different value. Repeat.

Question

I have a list of data that shows assets (Sub-Object) being used by another asset (Object). All of this data spans over 140 092 rows in excel when exported from our software.

Currently I am using "Find" to locate the "Sub-Asset" and then manually looking upwards for the "Main-Asset" number and then moving on to the next one, rinse repeat until I return to the first value returned.

I was wondering if there is a way to create a function either a basic excel function or using a VBA macro as I am somewhat familiar with this.