Formulas and Functions in Excel Sheet

[partha537]

I have a Called phone No and name in sheet1, (B2 and G2 field) and sheet2 Called Phone No (A2) have only phone number now I want how to get name in E-6 field  from Sheet1 in excel sheet ?

Sheet1

Phone No	Called Phone No	Call Date	Call Time	Type of Call	Duration	Name	Address
919800906666	917602334497	01-12-2022	10:45:58	CALL-IN	151	Dipankar Das	Asansol, West Bengal713325
919800906666	919635052580	01-12-2022	11:48:02	SMS-IN	0	Amrit Koley	Purulia, West Bengal, 713325

Sheet2

Called Phone No	Name ?
917602334497
919635052580

[#2]

You can use the VLOOKUP function in Excel to retrieve the name from Sheet1 and display it in the E6 field of Sheet2.
The formula would be =VLOOKUP(A2,Sheet1!$B$2:$H$3,7,FALSE).
This formula searches for the value in A2 of Sheet2 in the second column of Sheet1 (Called Phone No) and returns the value from the seventh column of Sheet1 (Name) in the same row where the match is found.

[#3 · Accepted solution]

#REFF
=VLOOKUP(A2,Sheet1!$B$2:$G$2,7,FALSE) Respected Sir, I am tried to execute the Vlook up formula in excel in connection with Call details record (CDR analysis), now my question is clear that in sheet2 I have multiple numbers in Called Phone Number (A2 to A3521) and Multiple Subscriber Name in Colum no. 7, (G2 to G3521) and Sheet 3 I have a pivot table with multiple number (A2 to A251) to count of calls (incoming, Outgoing, SMS in, SMS Out). Now I want Subscriber name in Pivot table (G6). Sheet2 CDRPhoneNo CalledPhoneNo CallDate CallTime TypeofCall Duration Sub Name_B Sub Address_B Tower Name _A TowerAddress_A Colum 7 is Subscriber Name Sheet3 (Pivot Table) Count of Duration Column Labels Row Labels CALL-IN CALL-OUT SMS-IN SMS-OUT Grand Total Subscriber Name ? 916294825540 1769 1644 100 14 3527 913413567420 1 1 Subscriber Name ?

[#4]

@partha537 

Is Sheet1 the real name of the first sheet that you mentioned? If not, use the real name in the formula.

[#5]

Respected Sir,
I am tried to execute the Vlook up formula in excel in connection with Call details record (CDR analysis), now my question is clear that in sheet2 I have multiple numbers in Called Phone Number (A2 to A3521) and Multiple Subscriber Name in Colum no. 7, (G2 to G3521) and Sheet 3 I have a pivot table with multiple number (A2 to A251) to count of calls (incoming, Outgoing, SMS in, SMS Out). Now I want Subscriber name in Pivot table (G6).

Sheet2

CDRPhoneNo CalledPhoneNo CallDate CallTime TypeofCall Duration Sub Name_B Sub Address_B Tower Name _A TowerAddress_A

Colum 7 is Subscriber Name

Sheet3 (Pivot Table)

Count of Duration Column Labels
Row Labels CALL-IN CALL-OUT SMS-IN SMS-OUT Grand Total Subscriber Name ?
916294825540 1769 1644 100 14 3527
913413567420 1 1 Subscriber Name ?