Create a formula
$10-30 USD
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!
Projektazonosító: #12937989
A projektről
Odaítélve:
20 szabadúszó tett átlagosan 20$ összegű árajánlatot erre a munkára
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.
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
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
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.
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
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
Hi, i will start right now, i have xperienced finish this kinds of projects. Best regards...............
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.
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!