Fill in automatically

Closed
iSaeed11 Posts 2 Registration date Wednesday January 6, 2016 Status Member Last seen January 7, 2016 - Jan 6, 2016 at 04:15 AM
iSaeed11 Posts 2 Registration date Wednesday January 6, 2016 Status Member Last seen January 7, 2016 - Jan 7, 2016 at 01:37 AM
Hello,
I have two colum in excel sheet
colum A1 contain big list of job titles each one of it have a code for example:

Job Title name Code
Director of Regulations Administration 1217201
Director of International Trade Department 1217211
Director of Collection and credit Department 1217221
Director of Strategic Planning Department 1217231
Director of Financial Planning and Coordination 1217241
Director of Training and Special Programmes 1217251
Director of cash flow Department 1217261

I want a formula that if I write on it for example " Director of Regulations Administration " it's gave me automatic it's code which is next to it " 1217201 "

Is that possible ?

Thanks



1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jan 6, 2016 at 11:24 AM
Since you said the list is big. Best option would be to have a hidden sheet or a visible sheet, where all the titles and codes are listed. The you can use the vlookup to populate the codes on your regular sheets
0
iSaeed11 Posts 2 Registration date Wednesday January 6, 2016 Status Member Last seen January 7, 2016
Jan 7, 2016 at 01:37 AM
How can I do that ?
0