Emp ID Name Dept Pay Rate Iferror

1054
1056
1067
1075
1078
4567
1196
1284
1052
1152
Emp ID Name Dept E-mail Phone Ext Location
1054 Sukhdev Singh Order Management Sukhdev@dummymail. 253 Building 1
1056 Dupesh Saini Order Management Dupesh@dummymail.c 226 Building 1
1067 Mohammad Order Management Mohammad@dummymai 228 Building 1
1075 Sarvodhya Bahri Purchase Sarvodhya@dummymail 231 Building 2
1078 Ritin Gupta Dispatch Ritin@dummymail.com 206 Building 2
1152 Mohammad Aatif Purchase Mohammad@dummymai 223 Building 2
1196 Sanjay Pant HR Sanjay@dummymail.co 394 Building 3
1284 Ankur Khera Legal Ankur@dummymail.com 229 Building 1
1290 Sumit Kumar Purchase Sumit@dummymail.com 218 Building 2
1293 Sunil Sahdev HR Sunil@dummymail.com 310 Building 3
1299 Rajeev Sood Finance Rajeev@dummymail.co 232 Building 1
1302 Satish Pal Legal Satish@dummymail.co 244 Building 1
1310 Mahender Singh R Finance Mahender@dummymail 242 Building 1
1329 Rajesh Kumar Dispatch Rajesh@dummymail.co 256 Building 2
1333 Niranjan Singh HR Niranjan@dummymail.c 227 Building 3
1368 Pardeep Mishra Purchase Pardeep@dummymail.c 237 Building 2
1509 Gulam Mohammad Order Management Gulam@dummymail.co 240 Building 1
1516 Sanjeev Kumar Dispatch Sanjeev@dummymail.c 210 Building 2
1529 Sada Patwal Legal Sada@dummymail.com 234 Building 1
1656 Sanjay Vivek Finance Sanjay@dummymail.co 254 Building 1
1672 Rahul Singh Finance Rahul@dummymail.com 219 Building 1
1673 Ambkesh Sehgal Purchase Ambkesh@dummymail. 217 Building 2
1676 Jaswinder Singh Wa Legal Jaswinder@dummymail 220 Building 1
1721 Gurmeet Singh HR Gurmeet@dummymail. 207 Building 3
1723 Vikas Sharma Legal Vikas@dummymail.com 250 Building 1
1758 Bhushan Gupta Dispatch Bhushan@dummymail. 212 Building 2
1792 Ajay Sikka Order Management Ajay@dummymail.com 216 Building 1
1814 Vikas HR Vikas@dummymail.com 208 Building 3
1908 Manoj Sarpal Order Management Manoj@dummymail.co 257 Building 1
1931 Manish Kwatra Dispatch Manish@dummymail.co 215 Building 2
1960 Anand Thakur Finance Anand@dummymail.co 255 Building 1
1964 Rhydham Aggarwal Dispatch Rhydham@dummymail. 213 Building 2
1975 Sanjay Saini Dispatch Sanjay@dummymail.co 230 Building 2
1983 Mr. Sunny Patel Order Management Mr.@dummymail.com 259 Building 1
1990 Gagandeep Finance Gagandeep@dummymai 303 Building 1
1995 Rakesh Bhardwaj Order Management Rakesh@dummymail.c 303 Building 1
1999 Amandeep And Ane HR Amandeep@dummymail 533 Building 3
 LOOKUP FUNCTION
production id product name qty rate
101 computer 5 30000
102 laptop 6 40000
103 keyboard 10 500
104 mouse 12 800
105 speaker 4 1000
Hire DateRate per day
16-Apr-91 787.50
25-Oct-79 857.50
20-Sep-87 1,018.50
07-Aug-92 787.50
01-Apr-86 714.00
21-Jan-90 857.50
01-Apr-98 696.50
04-Jan-85 861.00
03-Jan-85 927.50
14-Sep-84 714.00
21-Dec-89 854.00
06-Aug-84 997.50
04-Oct-86 805.00
22-Feb-89 724.50
16-Apr-90 710.50
11-Mar-83 857.50
19-Jun-85 927.50
06-Mar-85 665.00
28-Jan-87 791.00
14-Dec-87 864.50
16-Apr-90 833.00
25-Mar-92 829.50
26-Oct-81 752.50
06-Aug-90 682.50
10-Feb-78 976.50
18-Mar-82 784.00
24-Dec-90 721.00
04-Mar-89 857.50
15-May-84 717.50
20-Jun-89 689.50
13-Nov-86 815.50
17-Nov-91 647.50
01-Mar-96 647.50
28-Jun-97 770.00
14-Feb-98 766.50
01-Mar-98 822.50
05-Jul-98 710.50
 800
30000
 Inventory Status Check
Enter Product Code Here: XP200
Warehouse 1 Inventory:
Warehouse 2 Inventory:
Warehouse 3 Inventory:
Product Code: XP100 XP200 XP300 AX10 AX25 AX50
Warehouse 1 120 150 135 90 95 140
Warehouse 2 55 110 75 95 75 55
Warehouse 3 70 115 65 55 85 65
In case of any issue please contact me on below:
Whatsapp: 9818072997
Email: caamitjain2018@gmail.com

For More videos please subscribe our channel on Fintax Prime using below link
https://www.youtube.com/channel/UCSbhpRGXECpL5cBK6L_Ug6w?view_as=subscriber