SOLVED

New Contributor

Formulas and Functions in Excel Sheet

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
4 Replies

Re: Formulas and Functions in Excel Sheet

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.
best response confirmed by partha537 (New Contributor)
Solution

Re: Formulas and Functions in Excel Sheet

#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 ?

Re: Formulas and Functions in Excel Sheet

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

Re: Formulas and Functions in Excel Sheet

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 ?