Create a formula

完了済み 投稿 7年前 着払い
完了済み 着払い

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!

エクセル

プロジェクトID: #12937989

プロジェクトについて

20個の提案 リモートプロジェクト アクティブ 7年前

アワード:

$10 USD 0日以内
(21レビュー)
4.5

20人のフリーランサーが、平均$20 で、この仕事に入札しています。

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日以内
(327件のレビュー)
7.1
Khurramz

Hi! It can be done using vlookup formula .

$10 USD 1日以内
(228件のレビュー)
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, もっと

$30 USD 1日以内
(124件のレビュー)
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 もっと

$10 USD 1日以内
(123件のレビュー)
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 もっと

$15 USD 0日以内
(208件のレビュー)
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日以内
(68件のレビュー)
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日以内
(81件のレビュー)
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 もっと

$30 USD 0日以内
(49件のレビュー)
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 もっと

$12 USD 1日以内
(2件のレビュー)
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 もっと

$25 USD 2日以内
(レビュー1件)
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 もっと

$25 USD 1日以内
(0件のレビュー)
0.0
wfcgonly30

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

$13 USD 0日以内
(0件のレビュー)
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日以内
(0件のレビュー)
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日以内
(0件のレビュー)
0.0