Populating multiple columns in on sheet by referring to a column in another sheet

Hello,

I would appreciate any help with this problem i'm having in excel- I'm looking to populate rows in 2nd tab based on the data entered in the 1st tab. The rows to be populated in the 2nd tab resides in the 3rd tab. So a match has to be made on the data entered in the 1st tab. When a match is found on the 3rd tab then the corresponding rows from the 3rd tab should be listed on the 2nd tab.

I have an example.xls attached for clarity.

Thanks,example.xls

Lata

Is there anyone in the forum who could provide some insight with this problem? Thanks

There is no common factor in 2nd tab

In the 2nd tab I would like the asset and classification from the first tab and the matching attributes from the 3rd tab displayed. The common factor would be classification.

Let me re-write my problem. I have probably confused people and that's why I'm not getting any response.

I have 3 sheets. Sheet 1 has 2 columns. A & B
The 2nd sheet has 3 Columns : A, B & C
Sheet 3(Reference Sheet) has 2 columns: B & C

Now When I enter data in Column A & B of Sheet 1. I want sheet 2 to be automatically populated with information from column A&B of Sheet 1 and Column C from sheet 3(using the reference data of Column B in sheet 1). There is one to many relationship in sheet 3 between column b& C. So Sheet 2 could have multiple rows populated.

Looking forward for anyone in the forum to help me out PLEASE!

Thanks in advance,

Lata

There is no common factor from Sheet 2 that could be used as a reference.

Again, if values from sheet 1 are to automatically populated, sheet 3 has multiple rows against a single value. Say Class1 has 5 attributes. That wouldn't be the case in sheet 2