Auto populate multiple rows upon data being populated in another sheet

Could anyone help with this problem in excel-

In the spreadsheet I have attached, I want to auto populate all the columns in the Asset Attributes tab when the 'Asset Alias' and 'Asset Classification' columns are filled in the Asset tab.

There's one to many relationship between 'asset classification' and 'attributes'(shown in Asset Classification Relationship tab). So the 'asset alias' and 'asset classification' will be repeated for that many rows of attributes.

The attached spreadsheet has examples and what I want the final goal to look like.

Thank you so much in advance for any help provided.


Lata

Is there anyone who could help with this problem? I have tried several times asking the same question. This is very urgent and crucial for me. But my post is always bypassed. I'm willing to clarify more but no one even seems to ask any follow up questions about my problem or attempt to give a response.
I'm loosing hope here in this forum.