Master_List Creation

[James Perry]

Hello friends:

I have List_01 that contains 2 columns A & B.
Col A contains Sales_Reps ID # like 1, 5, 4 etc.
Col B contains Sales_Revenues.

I have another List_02 that contains 2 columns D & E.
Col D has the label Sales_Rep ID, strictly in ascending order…such as 1,2,3,4 etc.
Col E has the label Sales_Rep_Name as applicable.

What I want: An Excel formula to give a 'Master_List' with 3 columns that will display:
Sales_Rep ID in col G
Sales_Rep Name in col H
Sales_Rep_Revenue in col I

Thanku

 

[NARAYANK991]

Hi James ,

Why do you need to have 3 columns , since 2 of those are just replicating columns D and E of List_02 ?

Can you not add one more column , column F , to List_02 , and use a formula to lookup the Sales_Revenue from List_01 ?

Narayan

 

[James Perry]

Hello Narayan & good question. But the input is from different data sources & here's my solution.
Copy column A to Column G.
Copy column B to column I.
In column H enter the formula Vlookup(G2,$D2:$En, 2, 0).
Copy this formula down to $Hn where n represents the last row of the list.

Cheers!

 

[SirJB7]

Hi, James Perry!

Give a look at the uploaded file:
G2: =A2
H2: =BUSCARV(A2;D:E;2;FALSO) -----> in english: =VLOOKUP(A2,D:E,2,FALSE)
I2: =B2
Copy down G2:I2 up to non-empty row in columns A:B.

Regards!