XMATCH OR BEST ANSWER EXCEL - 12/01/2023 14:00 EST
$30-250 USD
Pagado a la entrega
I need:
1. Validated data matching. I am assuming by utilizing XMATCH.
Steps:
1. I paste a file in worksheet “Paste File” number of rows is variable, may be 2000. Payee column cells are blank
EX-1 PASTE FILE
Date Payee Amount Memo
7/1/2021 $56.25 DEBIT POS, AUT 070121 DDA PURCHASE SHELL SERVICE S STONY POINT * NY 4085404027491319
7/1/2021 $52.27 DEBIT POS, AUT 063021 DDA PURCHASE SHELL SERVICE S STONY POINT * NY 4085404027491319
7/1/2021 $2.12 DEBIT POS, AUT 070121 DDA PURCHASE WAWA 958 FORKED RIVER * NJ 4085404027491319
7/1/2021 $24.24 DEBIT POS, AUT 070121 DDA PURCHASE WAWA 191 PHILADELPHIA * PA 4085404027491319
2. Payee column cells are empty in “PASTE FILE”
EX-2 Validated File_Vendor List1
EntityType LineAccountName EntityRefName
Vendor 68403 Travel Expense:Meals while Traveling WAWA
Vendor 68403 Travel Expense:Meals while Traveling SHELL
3. I need as final product Original “Paste File” as “Vendor Output File” with Vendor cells populated. number of rows is variable, may be 2000.
Date Payee Amount Memo
7/1/2021 SHELL $56.25 DEBIT POS, AUT 070121 DDA PURCHASE SHELL SERVICE S STONY POINT * NY 4085404027491319
7/1/2021 SHELL $52.27 DEBIT POS, AUT 063021 DDA PURCHASE SHELL SERVICE S STONY POINT * NY 4085404027491319
7/1/2021 WAWA $2.12 DEBIT POS, AUT 070121 DDA PURCHASE WAWA 958 FORKED RIVER * NJ 4085404027491319
The information for Payee is derived from the Validated File_Vendor List1
Nº del proyecto: #35735936
Sobre el proyecto
Adjudicado a:
19 freelancers están ofertando un promedio de $123 por este trabajo
Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I'd love to work together on your project. I'm so responsible and kind, I'll always send you the files on time and Más
Hello Edmund C., We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on Accounting Lets connect in chat so that Más
--------------I CAN DO IT RIGHT AWAY--------------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VBA Scripting, building an excel file, excel dashboard, Más
Hi there, I am ready to give you sample work before create offer. I'm available right now. "Do you have time for a quick CHAT"? Waiting for your reply. Thank you!
Dear Sir/Ma’am, I am very much interested in your job posted. You have been looking for a Software Developer who is able to deliver you the best. I consider myself as the right choice for you because I have the righ Más
Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on Data Processing, Data Entry, Accounting, Excel, Softwa Más
Greetings! Do you need readable, accurate and specific writing and proofreading for your project? I am here to help you as a writer and editor. I can assure you the high quality work enriched with creativity. My rese Más
I am jop know i am free, i am in maternal leave, so i have a full of time for doing my jops, if i get the chance i willfinish it on time and doing properly, thanks
Hello..I am palak and i am specialised in data entry tally erp 9 and tally prime and excel... i think i am perfect for your project and i would really love to do this project..!
Soy amable, eficaz, responsable, tengo conocimientos en computadoras, disponibilidad inmediata y además tengo experiencia manejando personas.