Lookup then auto popular the Link to field?

Hi, I need help. In a base, I have two sheets, the report and vendors. In the vendors sheet I made a lookup field column and created the lookup column. In the configuration, I linked the report and the report vendor category column. I can go to vendor category column and click the plus mark to add a record. The report had 1000+ rows. I don’t want to add these in manual 1000+ times. How do I get the vendor category column to auto popular with all the matching records? What am I doing wrong?
Thank you

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.