Create a formula

Befejezett Kiadva: 7 évvel ezelőtt Kiszállításkor fizetve
Befejezett Kiszállításkor fizetve

Uaing MS365 Excel, I have two lists, one 15,000 rows of a customer base. Another spreadsheet of 1000 rows of ENROLLED customers into a certain program. Both spreadsheets have the identifer which is the unique customer ID, ie. customer #12345. I need to put a "Y" beside all customers that are enrolled (on the 2nd spreadsheet) on a cell in the right row and at the end of the columns. So it could look like this on the 15000 row customer spreadsheet:

Customer Phone # Enrolled?

1233 999-333-2222

1234 999-322-1111 Y

1232 999-222-4444

1221 999-111-4444 Y

It is probaby a LOOKUP, MATCH, VLOOKUP formula but I need some help please!

Excel

Projektazonosító: #12937989

A projektről

20 ajánlat Távolról teljesíthető projekt Utoljára aktív: 7 évvel ezelőtt

Odaítélve:

$10 USD 0 napon belül
(21 értékelés)
4.5

20 szabadúszó tett átlagosan 20$ összegű árajánlatot erre a munkára

cgullapalli

Hi, I am good at Excel and vba. Please provide me the excel file to write the formula. Looking forward to discuss in the chat.

$14 USD 0 napon belül
(327 vélemény)
7.1
Khurramz

Hi! It can be done using vlookup formula .

$10 USD 1 napon belül
(228 vélemény)
6.7
cugamelover

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, Továbbiak

$30 USD 1 napon belül
(124 vélemény)
6.6
sujitkar

Hello! Thank you for posting the project. I have read and understood your requirements, and this would require some concatenation along with lookup formula. I have excellent skills in MS Excel and can do this in Továbbiak

$10 USD 1 napon belül
(123 vélemény)
6.6
MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. You are on the right track, we will use MATCH, INDEX and IF formulas and we will get exactly what you need. If you are interested, just Továbbiak

$15 USD 0 napon belül
(208 vélemény)
5.9
Kalpanasekhar

Hi There, I can complete it in the next couple of hours. Please send me those sheet. My name is Kalp. Looking forward to hear from you. Thanks. Kalpanasekhar

$24 USD 1 napon belül
(68 vélemény)
6.0
bdoutsource

Dear sir, Greetings. Plz provide me the excel and i would solve it now for you. We need match, index, vlookup or a simple macro. Would need 15 mins to solve this i think.

$30 USD 1 napon belül
(81 vélemény)
5.9
sangwanpankajs

hello sir i can do this work ....i am an expert in excel ....i have used these functions before ( v lookup , match etc) i have done many excel projects with excellent ratings so please msg me to discuss t Továbbiak

$30 USD 0 napon belül
(49 vélemény)
4.9
scorpionobaid01

Hi dear I am available for this project Have strong exp in excel I am an Acca member currently working in finance dept of Qatar Airways Can assist u with high regards Plz share more info to proceed further Thanks Looki Továbbiak

$12 USD 1 napon belül
(2 vélemény)
2.3
JoynierB

Dear Employer, Hello, how are you.? My name is Joynier Barrios, I'm a native Spanish speaker with excellent English. I'm a responsible person with enough time and experience typing from PDF to an Excel Spreadsheet, ma Továbbiak

$25 USD 2 napon belül
(1 Visszajelzés)
1.0
sidkaz

Hello My name is Sid, and after seeing your listing I feel like we could collaborate well with each other on this project. My specialties are in the field of accounts and finance. Being a qualified accountant I am we Továbbiak

$25 USD 1 napon belül
(0 vélemény)
0.0
wfcgonly30

Hi, i will start right now, i have xperienced finish this kinds of projects. Best regards...............

$13 USD 0 napon belül
(0 vélemény)
0.0
coderX15

I am an enthusiastic data scientist working in the machine learning field and like to work on other things as well. Please award me this project.

$10 USD 1 napon belül
(0 vélemény)
0.0
rajapitalia

Hi - happy to help. I spend hours on excel as part of my job! I'm very efficient. A quick vlookup will do the trick but let me worry about that!

$20 USD 1 napon belül
(0 vélemény)
0.0