lookup and extract data from columns of different sheets to get corresponding values

sapxl

New Member
Joined
Jun 20, 2020
Messages
24
Office Version
  1. 2016
  2. 2013
  3. 2011
  4. 2010
  5. 2007
Platform
  1. Windows
Dear Friends,

I have data where i need to extract the columns in each sheet has common columns and that columns have corresponding values and information. I need to extract those columns from other sheets... hope i'm clear with the information I have provided. Please let us now if need more clarity on this.

Below is the order for extraction in the columns from each sheet.

UserName|RoomNumber|Roles|T-codes|AuthorizationObject|AuthorizationValue|StartDate|EndDate |

Thanks, your help is much appreciated.

Below are the sheets info for -

USERS by ADDRESS-DATA_sheet:

MasterSheet-DataExtract 1.0.xlsx
ABCD
1UsersRoom NumberComplete nameE-Mail Address
21000010210000102PARAYIL SUSHAMA SALAL APPU
31000011710000117SIDNEY CAJETAN FERREIRA
41000014410000144KENNETH CHRISTOPHER A . TWEEDIE
51000021310000213DONNABELLE VELASCOdonna.v@supercare.ae
61000023210000232Reggie Gonzales
71000023910000239MOHAMMED SAMIUDDIN
81000024210000242ZAHID BALUCHI FAIZ MUHAMMAD BALOCH
91000028810000288EMELYN REPOLLO VIERNES
101000029710000297JESSICA MENDEJAR MONJE
111000030910000309IRENE PLEGARIA CERTEZA
121000037110000371Josephine Notario Sunga
131000037510000375SUHAEL IRFAN UKAYEsuhael@sunandsandsports.comsuhael@sunandsandsports.com
141000038810000388GIRISH KUMAR
151000039010000390WINDELYN RIZON LUSTERIO
161000042110000421SANJEV KUMAR SHRESTHA
171000045210000452DOVY ESPINOZA MANGANTI MANGANTIdovy@sunandsandsports.com
181000053810000538MELVIN SALAO
191000056810000568MARICEL MANDAP
201000057010000570BRIDGID GIMENEZ
211000060210000602MOHAMMAD SHARIQUE ALI
221000065710000657aisal Nadeem Muhammad
231000065910000659DONALD KABILING
241000066810000668HILDA MENDRES
251000067410000674MARJORIE CABATBAT
261000068710000687MILAN ERANGA SENANAYAKE MOHOTTI MUDIYANSELAGE
271000069010000690HIRAN DARSHE SAMARAWEERA JAYAWARDANA
281000069210000692RUPEN MUKHIA
291000074010000740ROCHEL ROSARIO
301000083810000838LEAH BAYLON
311000083910000839JONALYN FRANCISCO
321000084010000840JAYNOVER JIMENEZ
331000087910000879NEVIL PRIYANKARA WANATUNGA JAYAMAHA HITIKAMILLAGE
341000089710000897PRADEEP NAMBRATH
351000090610000906SHAN PREETHI MEGODAGAMA
361000090710000907WASEEM SHARIEF SHARIEF
371000093010000930AGHIL PUTHPULLY GAGANAN
381000099610000996Mahmoud Gaber Afify Zineldin
391000101710001017RANDOLPH D SOUZA
401000104210001042MOHAMMED ARAFATH
411000106110001061Ali Raza
421000110310001103Emmanuel 10001103
431000110510001105FRANK LESLIE DSILVA
441000111810001118RUPEN THAPA
451000112110001121SYED AHMED MOHAMADI
461000114110001141KOSALA HARSHA NETHTHI KUMARGE
471000118210001182FARIMAN POUR
48100012901000129010001290
491000137710001377DEEPIKA MANOJ MALHOTRAm.deepika@farmfresh.ae
501000156810001568Shehzad Youhana
USERS BY ADDRESS-DATA_SUIM



Userslist with Roles:


MasterSheet-DataExtract 1.0.xlsx
ABC
1User NameFull NameRole
210000102PARAYIL SUSHAMA SALAL APPUZ_BC_ENDUSER
310000117SIDNEY CAJETAN FERREIRAZ_BC_ENDUSER
410000144KENNETH CHRISTOPHER A . TWEEDIEZ_BC_ENDUSER
510000213DONNABELLE VELASCOZ_BC_ENDUSER
610000213DONNABELLE VELASCOZ_COMMON_HR
710000213DONNABELLE VELASCOZR_HCM_HR_LIMITED_HC
810000213DONNABELLE VELASCOZR_HCM_HR_SC
910000213DONNABELLE VELASCOZR_HCM_HR_TA_ONBOFF_HC
1010000232Reggie GonzalesZ_BC_ENDUSER
1110000239MOHAMMED SAMIUDDINZ_BC_ENDUSER
1210000242ZAHID BALUCHI FAIZ MUHAMMAD BALOCHZ_BC_ENDUSER
1310000288EMELYN REPOLLO VIERNESZ_BC_ENDUSER
1410000297JESSICA MENDEJAR MONJEZ_BC_ENDUSER
1510000309IRENE PLEGARIA CERTEZAZ_BC_ENDUSER
1610000309IRENE PLEGARIA CERTEZAZ_COMMON
1710000309IRENE PLEGARIA CERTEZAZ_RTL_MIM_PDA_OPERATIONS
1810000309IRENE PLEGARIA CERTEZAZ_RTL_OBJ_COMP_CODE_1000
1910000309IRENE PLEGARIA CERTEZAZ_RTL_OBJ_PURCH_GRP_ALL
2010000309IRENE PLEGARIA CERTEZAZ_RTL_OBJ_PURCH_ORG_ALL
2110000309IRENE PLEGARIA CERTEZAZ_RTL_TRN_MIM_PDA_OPERATIONS
2210000309IRENE PLEGARIA CERTEZAZSAP_NBPR_INSTORE_MIM
2310000309IRENE PLEGARIA CERTEZAZSAP_NBPR_INSTORE_MIM_1031
2410000371Josephine Notario SungaZ_BC_ENDUSER
2510000371Josephine Notario SungaZ_COMMON
2610000371Josephine Notario SungaZ_RTL_MIM_PDA_OPERATIONS
2710000371Josephine Notario SungaZ_RTL_OBJ_COMP_CODE_1000
2810000371Josephine Notario SungaZ_RTL_OBJ_PURCH_GRP_ALL
2910000371Josephine Notario SungaZ_RTL_OBJ_PURCH_ORG_ALL
3010000371Josephine Notario SungaZ_RTL_TRN_MIM_PDA_OPERATIONS
3110000371Josephine Notario SungaZSAP_NBPR_INSTORE_MIM
3210000371Josephine Notario SungaZSAP_NBPR_INSTORE_MIM_1227
3310000375SUHAEL IRFAN UKAYEsuhael@sunandsandsports.comZ_BC_ENDUSER
3410000375SUHAEL IRFAN UKAYEsuhael@sunandsandsports.comZ_COMMON_HR
3510000375SUHAEL IRFAN UKAYEsuhael@sunandsandsports.comZR_HCM_GR_MGR_ALL
3610000375SUHAEL IRFAN UKAYEsuhael@sunandsandsports.comZR_HCM_HR_NORESTRICTION
3710000388GIRISH KUMARZ_BC_ENDUSER
3810000388GIRISH KUMARZ_COMMON
3910000388GIRISH KUMARZ_RTL_MIM_PDA_OPERATIONS
4010000388GIRISH KUMARZ_RTL_OBJ_COMP_CODE_1000
4110000388GIRISH KUMARZ_RTL_OBJ_PURCH_GRP_ALL
4210000388GIRISH KUMARZ_RTL_OBJ_PURCH_ORG_ALL
4310000388GIRISH KUMARZ_RTL_TRN_MIM_PDA_OPERATIONS
4410000388GIRISH KUMARZSAP_NBPR_INSTORE_MIM
4510000388GIRISH KUMARZSAP_NBPR_INSTORE_MIM_1201
4610000390WINDELYN RIZON LUSTERIOZ_BC_ENDUSER
4710000390WINDELYN RIZON LUSTERIOZ_COMMON
4810000390WINDELYN RIZON LUSTERIOZ_RTL_MIM_PDA_OPERATIONS
4910000390WINDELYN RIZON LUSTERIOZ_RTL_OBJ_COMP_CODE_1000
5010000390WINDELYN RIZON LUSTERIOZ_RTL_OBJ_PURCH_GRP_ALL
UsersList with Roles



TCODES IN ROLES AGR_1251


MasterSheet-DataExtract 1.0.xlsx
ABCDEF
1RoleIDAuthorization objectUser Master Maint.: Authorization NameField nameAuthorization value (T-codes)
2ZR_HCM_AUDITROLE48S_TCODET-GP01049400TCDZHR037N
3ZR_HCM_DIRECTOR_HR51S_TCODET-GD28053901TCDPT_QTA10
4ZR_HCM_DIRECTOR_HR52S_TCODET-GD28053901TCDPY_KW_KWT_RP
5ZR_HCM_DIRECTOR_HR53S_TCODET-GD28053901TCDPY_OM_OMN_RP
6ZR_HCM_DIRECTOR_HR54S_TCODET-GD28053901TCDPY_QA_HQAPDEX0
7ZR_HCM_DIRECTOR_HR55S_TCODET-GD28053901TCDS_AHR_61016354
8ZR_HCM_DIRECTOR_HR56S_TCODET-GD28053901TCDS_AHR_61016358
9ZR_HCM_DIRECTOR_HR57S_TCODET-GD28053901TCDS_AHR_61016360
10ZR_HCM_DIRECTOR_HR58S_TCODET-GD28053901TCDS_AHR_61016362
11ZR_HCM_DIRECTOR_HR59S_TCODET-GD28053901TCDS_AHR_61016369
12ZR_HCM_DIRECTOR_HR60S_TCODET-GD28053901TCDS_AHR_61016370
13ZR_HCM_DIRECTOR_HR61S_TCODET-GD28053901TCDS_AHR_61016373
14ZR_HCM_DIRECTOR_HR62S_TCODET-GD28053901TCDS_AHR_61016374
15ZR_HCM_DIRECTOR_HR63S_TCODET-GD28053901TCDS_AHR_61016376
16ZR_HCM_DIRECTOR_HR64S_TCODET-GD28053901TCDS_AHR_61016378
17ZR_HCM_DIRECTOR_HR65S_TCODET-GD28053901TCDS_AHR_61016380
18ZR_HCM_DIRECTOR_HR66S_TCODET-GD28053901TCDS_AHR_61016381
19ZR_HCM_DIRECTOR_HR73S_TCODET-GD28053901TCDHRAE_EMIRATIZATION
20ZR_HCM_DIRECTOR_HR74S_TCODET-GD28053901TCDPA10
21ZR_HCM_DIRECTOR_HR75S_TCODET-GD28053901TCDPA20
22ZR_HCM_DIRECTOR_HR76S_TCODET-GD28053901TCDPC00_M99_CLGV09
23ZR_HCM_DIRECTOR_HR77S_TCODET-GD28053901TCDPC00_M99_CWTR
24ZR_HCM_DIRECTOR_HR78S_TCODET-GD28053901TCDPC00_M99_DKON
25ZR_HCM_DIRECTOR_HR79S_TCODET-GD28053901TCDPPOS_OLD
26ZR_HCM_DIRECTOR_HR81S_TCODET-GD28053901TCDPT03
27ZR_HCM_DIRECTOR_HR89S_TCODET-GD28053901TCDPT_BAL00
28ZR_HCM_DIRECTOR_HR92S_TCODET-GD28053901TCDS_AHR_61016491
29ZR_HCM_DIRECTOR_HR93S_TCODET-GD28053901TCDS_AHR_61016513
30ZR_HCM_DIRECTOR_HR94S_TCODET-GD28053901TCDS_AHR_61016514
31ZR_HCM_DIRECTOR_HR95S_TCODET-GD28053901TCDS_AHR_61016515
32ZR_HCM_DIRECTOR_HR96S_TCODET-GD28053901TCDS_AHR_61016516
33ZR_HCM_DIRECTOR_HR97S_TCODET-GD28053901TCDS_AHR_61016517
34ZR_HCM_DIRECTOR_HR98S_TCODET-GD28053901TCDS_AHR_61016522
35ZR_HCM_DIRECTOR_HR99S_TCODET-GD28053901TCDS_AHR_61016527
36ZR_HCM_DIRECTOR_HR100S_TCODET-GD28053901TCDS_AHR_61016528
37ZR_HCM_DIRECTOR_HR101S_TCODET-GD28053901TCDS_AHR_61016529
38ZR_HCM_DIRECTOR_HR102S_TCODET-GD28053901TCDS_AHR_61016532
39ZR_HCM_DIRECTOR_HR103S_TCODET-GD28053901TCDS_AHR_61016533
40ZR_HCM_DIRECTOR_HR104S_TCODET-GD28053901TCDS_AHR_61018831
41ZR_HCM_DIRECTOR_HR105S_TCODET-GD28053901TCDS_AHR_61018869
42ZR_HCM_DIRECTOR_HR113S_TCODET-GD28053901TCDS_L9C_94000095
43ZR_HCM_DIRECTOR_HR114S_TCODET-GD28053901TCDS_PH0_48000450
44ZR_HCM_DIRECTOR_HR115S_TCODET-GD28053901TCDS_PH0_48000510
45ZR_HCM_DIRECTOR_HR116S_TCODET-GD28053901TCDS_PH9_46000156
46ZR_HCM_DIRECTOR_HR117S_TCODET-GD28053901TCDS_PH9_46000216
47ZR_HCM_DIRECTOR_HR118S_TCODET-GD28053901TCDS_PH9_46000217
48ZR_HCM_DIRECTOR_HR119S_TCODET-GD28053901TCDS_PH9_46000218
49ZR_HCM_DIRECTOR_HR120S_TCODET-GD28053901TCDS_PH9_46000221
50ZR_HCM_DIRECTOR_HR121S_TCODET-GD28053901TCDS_PH9_46000222
TCODES IN ROLES AGR_1251



ROLES USERS WITH T-CODES AUTH:


MasterSheet-DataExtract 1.0.xlsx
ABCD
1RoleUser NameAuthorization ObjectAuthorization value
2ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEZHR048
3ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEZHR045N
4ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEZHR045
5ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEZHR031
6ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEPA70
7ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEPCP0
8ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEPP01
9ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEPT60
10ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEPY_AE_HAEPAEZ0
11ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_AHR_61016360
12ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_AHR_61016362
13ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_AHR_61016369
14ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_AHR_61016380
15ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_AHR_61016381
16ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_AHR_61016492
17ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_AHR_61016493
18ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_AHR_61016494
19ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_AHR_61016495
20ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_AHR_61016496
21ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_AHR_61016509
22ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_PH0_48000450
23ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_PH0_48000510
24ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_PH9_46000216
25ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_PH9_46000221
26ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODES_PH9_46000222
27ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEZHR001
28ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEZHR004
29ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEZHR005
30ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEPA40
31ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEPA42
32ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEZHR014
33ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_TCODEPA40
34ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_ORGIN*
35ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_ORGINR
36ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_ORGIN0000
37ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_ORGIN0001
38ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_ORGIN0002
39ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_ORGIN0003
40ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_ORGIN
41ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_ORGIN
42ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_ORGIN
43ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_ORGIN*
44ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_ORGIN
45ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_PCLXR
46ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_PCLX*
47ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_PCLXR
48ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_PCLXS
49ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_PCLXU
50ZR_HCM_HR_PSP_BEAUTYC.ACHARYAP_PCLXPC
ROLES USERS WITH T-CODES AUTH



AUTHDATA PROFILE USERLIST VALUES:


MasterSheet-DataExtract 1.0.xlsx
BCDE
1Authorization ObjectUser Master Maint.: Authorization NameField nameAuthorization value
2PLOGT-GP01099501SUBTYP*
3PLOGT-GP01099501SUBTYP*
4PLOGT-GP01099501SUBTYP*
5PLOGT-GP01099501SUBTYP*
6PLOGT-GP01099501SUBTYP*
7PLOGT-GP01099501SUBTYP*
8PLOGT-GP01099501SUBTYP*
9PLOGT-GP01099503SUBTYP*
10PLOGT-GP01099503SUBTYP*
11PLOGT-GP01099503SUBTYP*
12PLOGT-GP01099503SUBTYP*
13PLOGT-GP01099503SUBTYP*
14PLOGT-GP01099503SUBTYP*
15PLOGT-GP01099503SUBTYP*
16PLOGT-GD28055600ISTAT*
17PLOGT-GD28055600ISTAT*
18PLOGT-GD28055600ISTAT*
19PLOGT-GD28055600ISTAT*
20PLOGT-GD28055600ISTAT*
21PLOGT-GD28055600ISTAT*
22PLOGT-GD28055600ISTAT*
23PLOGT-GD28055600ISTAT*
24PLOGT-GD28055600ISTAT*
25PLOGT-GD28055600SUBTYP*
26PLOGT-GD28055600SUBTYP*
27PLOGT-GD28055600SUBTYP*
28PLOGT-GD28055600SUBTYP*
29PLOGT-GD28055600SUBTYP*
30PLOGT-GD28055600SUBTYP*
31PLOGT-GD28055600SUBTYP*
32PLOGT-GD28055600SUBTYP*
33PLOGT-GD28055600SUBTYP*
34PLOGT-GD28055601SUBTYP*
35PLOGT-GD28055601SUBTYP*
36PLOGT-GD28055601SUBTYP*
37PLOGT-GD28055601SUBTYP*
38PLOGT-GD28055601SUBTYP*
39PLOGT-GD28055601SUBTYP*
40PLOGT-GD28055601SUBTYP*
41PLOGT-GD28055601SUBTYP*
42PLOGT-GD28055601SUBTYP*
43PLOGT-GD28055603SUBTYP*
44PLOGT-GD28055603SUBTYP*
45PLOGT-GD28055603SUBTYP*
46PLOGT-GD28055603SUBTYP*
47PLOGT-GD28055603SUBTYP*
48PLOGT-GD28055603SUBTYP*
49PLOGT-GD28055603SUBTYP*
50PLOGT-GD28055603SUBTYP*
AUTHDATA_PROFILE_USERLIST VALUE

MasterSheet-DataExtract 1.0.xlsx
KLMN
1RoleUser NameStart dateEnd date
2ZR_HCM_HR_SPORTS1000269011/10/201912/31/9999
3ZR_HCM_HR_SPORTSA.FAHMY11/10/201912/31/9999
4ZR_HCM_HR_SPORTSHEMANGI.S11/10/201912/31/9999
5ZR_HCM_HR_SPORTSISRAA.S11/10/20192/29/2020
6ZR_HCM_HR_SPORTSJ.BEJO11/10/20192/15/2021
7ZR_HCM_HR_SPORTSSARAH.C1/7/20212/15/2021
8ZR_HCM_HR_SPORTSDEEPTHI.K12/15/20202/15/2021
9ZR_HCM_HR_SPORTS1000269011/10/201912/31/9999
10ZR_HCM_HR_SPORTSA.FAHMY11/10/201912/31/9999
11ZR_HCM_HR_SPORTSHEMANGI.S11/10/201912/31/9999
12ZR_HCM_HR_SPORTSISRAA.S11/10/20192/29/2020
13ZR_HCM_HR_SPORTSJ.BEJO11/10/20192/15/2021
14ZR_HCM_HR_SPORTSSARAH.C1/7/20212/15/2021
15ZR_HCM_HR_SPORTSDEEPTHI.K12/15/20202/15/2021
16ZR_HCM_HR_SSSANNETTE.CAST7/29/20166/30/2019
17ZR_HCM_HR_SSSELISABETA.C5/9/20176/30/2019
18ZR_HCM_HR_SSSHEMANGI.S3/12/20196/30/2019
19ZR_HCM_HR_SSSJ.BEJO3/12/20196/30/2019
20ZR_HCM_HR_SSSK.AGINA2/5/20196/30/2019
21ZR_HCM_HR_SSSKHADIJAH.M2/5/20196/30/2019
22ZR_HCM_HR_SSS100026903/12/20196/30/2019
23ZR_HCM_HR_SSSS.MAHDY7/29/20166/30/2019
24ZR_HCM_HR_SSSSHARJEEL.K3/20/20176/30/2019
25ZR_HCM_HR_SSSANNETTE.CAST7/29/20166/30/2019
26ZR_HCM_HR_SSSELISABETA.C5/9/20176/30/2019
27ZR_HCM_HR_SSSHEMANGI.S3/12/20196/30/2019
28ZR_HCM_HR_SSSJ.BEJO3/12/20196/30/2019
29ZR_HCM_HR_SSSK.AGINA2/5/20196/30/2019
30ZR_HCM_HR_SSSKHADIJAH.M2/5/20196/30/2019
31ZR_HCM_HR_SSS100026903/12/20196/30/2019
32ZR_HCM_HR_SSSS.MAHDY7/29/20166/30/2019
33ZR_HCM_HR_SSSSHARJEEL.K3/20/20176/30/2019
34ZR_HCM_HR_SSSANNETTE.CAST7/29/20166/30/2019
35ZR_HCM_HR_SSSELISABETA.C5/9/20176/30/2019
36ZR_HCM_HR_SSSHEMANGI.S3/12/20196/30/2019
37ZR_HCM_HR_SSSJ.BEJO3/12/20196/30/2019
38ZR_HCM_HR_SSSK.AGINA2/5/20196/30/2019
39ZR_HCM_HR_SSSKHADIJAH.M2/5/20196/30/2019
40ZR_HCM_HR_SSS100026903/12/20196/30/2019
41ZR_HCM_HR_SSSS.MAHDY7/29/20166/30/2019
42ZR_HCM_HR_SSSSHARJEEL.K3/20/20176/30/2019
43ZR_HCM_HR_SSSANNETTE.CAST7/29/20166/30/2019
44ZR_HCM_HR_SSSELISABETA.C5/9/20176/30/2019
45ZR_HCM_HR_SSSHEMANGI.S3/12/20196/30/2019
46ZR_HCM_HR_SSSJ.BEJO3/12/20196/30/2019
47ZR_HCM_HR_SSSK.AGINA2/5/20196/30/2019
48ZR_HCM_HR_SSSKHADIJAH.M2/5/20196/30/2019
49ZR_HCM_HR_SSS100026903/12/20196/30/2019
50ZR_HCM_HR_SSSS.MAHDY7/29/20166/30/2019
AUTHDATA_PROFILE_USERLIST VALUE
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,223,231
Messages
6,170,884
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top