excel - VBA - Allocation of Information based on another cell's value -


i have list of assets wish allocate resources based on whether or not available.

both lists variable in length.

i chasing macro down list 1 , if there resource available on list 2 , take next asset.

try range.find method

range.find method