Report

Respective names required

Ask a question raja - Latest answer on Sep 15, 2016 10:53AM
Hello CCM,
Please give me solutions to solve my problem..
1) I have created 2 worksheets,
one sheet having two columns like below
Code member name
19401 xxxxxxxxxx
19402 xxxxxxxxxx
.
.
.
19415 xxxxxxxxx
The second sheet having below columns like below.
Code key type1 type2 type3 type4 member name
19415 xx xx xx xx xx xxxxxxxxxxxxxxxx
19407 xx xx xx xx xx xxxxxxxxxxxxxxxxx
My question is that:
if i enter code number code column in sheet 2, automatically the name of the member in sheet 1 of member column will appear in the sheet 2 of member name column.
Thanks,
Regards,
Ganesh
See more 
Helpful
+0
moins plus
Ganesh, Good Morning.

The VLOOKUP Function was specially created for this case.

Sheet 1
Code........... --> A1:A100
Member name --> B1:B100

Sheet 2
Code --> A1:A50
Key.. --> B1:B50
Type1 -> C1:C50
Type2 -> D1:D50
Type3 -> E1:E50
Type4 -> F1:F50
Member name --> G1:G50 --> FORMULA

Try to use:
G1 --> =VLOOKUP(A1,'Sheet 1'!A1:B100,2,FALSE)

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Add comment
Helpful
+0
moins plus
Hello Belo Horizonte, Brasil.
Marcílio Lobão,

Thank you sir.. the problem is resolved..

One more doubt...?

Column 1 column 2
BM 4.30
CM 5.30
BM 6.03
BM 4.50
CM 9.10
.
.
.
BM 2.81

My Question : how to calculate the BM values sum only?
Give me formula ?

Kind Regards,
Ganesh
Add comment
Helpful
+0
moins plus
Ganesh, Good Morning.

The SUMIF Function will work for you.

Code --> A1:A100
Value --> B1:B100

Try to use:
D1 --> =SUMIF(A1:A100,"BM",B1:B100)

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!