Forum Discussion
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 |
- #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 ?
- 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.- #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 ?- 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 ?
