Create a formula

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

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

Project ID: #12937989

About the project

20 proposals Remote project Active 7 years ago

Awarded to:

$10 USD in 0 days
(21 Reviews)
4.5

20 freelancers are bidding on average $20 for this job

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 in 0 days
(327 Reviews)
7.1
Khurramz

Hi! It can be done using vlookup formula .

$10 USD in 1 day
(228 Reviews)
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, More

$30 USD in 1 day
(124 Reviews)
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 More

$10 USD in 1 day
(123 Reviews)
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 More

$15 USD in 0 days
(208 Reviews)
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 in 1 day
(68 Reviews)
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 in 1 day
(81 Reviews)
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 More

$30 USD in 0 days
(49 Reviews)
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 More

$12 USD in 1 day
(2 Reviews)
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 More

$25 USD in 2 days
(1 Review)
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 More

$25 USD in 1 day
(0 Reviews)
0.0
wfcgonly30

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

$13 USD in 0 days
(0 Reviews)
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 in 1 day
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0