If statement with vlookup and hlookuptrabajos

...talented financial writer with a keen eye for detail, capable of creating 1 to 10 demo bank statements specifically for a business account. - Required Format: The bank statements need to be in PDF format. - Account Type: The statements should reflect transactional activity for a business account. Ideal skills include: - Familiarity with financial statement preparation - Proficient in PDF generation - Previous experience creating bank statements or similar financial documents. By the end of this project, I expect professionally drawn-up bank statements that mimic authentic business transaction flows. Apply if you're well-versed in financial terminologies and possess excellent writing standards. Must include account numbers to be provided for ...

...ghostwriter to craft an engaging and educational 38,000-word eBook focused on longevity. The book aims to blend scientific insights with practical wisdom, exploring how readers can achieve a longer, healthier life by adopting the lifestyle habits of the world's longevity hotspots. Key Project Details: 1) Word Count: Approximately 38,000 words 2) Goal: The primary aim of this ebook is to educate readers about health and fitness, offer actionable tips for improving nutrition, and share strategies for promoting longevity. 3) Timeline: 2.5 to 3 months for completion, with regular milestone check-ins 4) Target Audience: Aging adults, health enthusiasts, and anyone interested in preventative health strategies 5) Tone and Style: Conve...

I am ...Payable, Accounts Receivable, and Inventory modules. Key Responsibilities: - Reviewing and assessing the accuracy of data in the General Ledger, Accounts Payable, Accounts Receivable, and Inventory modules. - Ensuring the completeness of financial data in the system. - Conducting data reconciliation to identify any discrepancies. - Producing detailed findings on the Balance Sheet, Income Statement, and Cash flow statement. Ideal Skills and Experience: - Proven track record in financial auditing, particularly within ERP systems. - Strong understanding of financial reporting and reconciliation. - Experience with Odoo ERP would be advantageous but not essential. - Excellent attention to detail and analytical skill...

I need a skilled graphics designer to create a vibrant, bold portfolio for my software startup. Mandatory Inclusion: - Diverse sections: Home/Introduction,...graphics designer to create a vibrant, bold portfolio for my software startup. Mandatory Inclusion: - Diverse sections: Home/Introduction, Services, Portfolio/Projects, About Us, Contact, Case Studies, and Clientele. - Key elements: Previous projects and cases studies, my startup's mission statement and company values. Preferrable Skills: - Strong, bold and vibrant design proficiency. - Prior experience in creating tech startup portfolios. - Good understanding of software startups, able to highlight our services and expertise in a persuasive manner. Your creativity will make our ser...

I'm in need of a highly skilled and creative professional who can craft a top-notch company profile for us, that will serve a triple purpose: attracting potential clients, showcasing our expertise, and providing detailed information about our products and services. The profile will be primarily used to target potential clients and investors. Key elements to be included: - Strongly worded, engaging mission and vision statement - Compelling success stories and testimonials Ideal candidates for this project should be able to: - Demonstrate prior experience in creating engaging and effective company profiles - Have a good understanding of how to cater to both clients and investors through the same document - Possess excel...

I am in need of an experienced accounting professional who can assist me with the comprehensive analysis of my business's financial statements. Key Requirements: - Expertise in financial statement analysis - Proficiency in analyzing balance sheets and cash flow statements Ideal Skills and Experience: - Proven track record in conducting intricate financial analyses - Strong grasp of accounting principles and best practices - Background in [industry specific experience, if you have any] could be beneficial, but not mandatory. - Familiarity with [specific accounting software, if needed] I have attached sample sheet. My required company is NESTLE.

I'm in need of a skilled developer with expertise in Yii framework to add new functionality to our existing system that serves a financial services purpose. The successful candidate will be responsible for implementing the following features: - Add menu new menu items using the language file - Bank statement mapping - Bank statement import - Bank statement transaction allocation A full specification is available for the selected candidate. Ideal skills and experience for this job include: - Proficiency in Yii framework - Strong PHP skills I look forward to your proposal for this project.

The objective is to design a digital product disclosure statement which effectively caters to individual consumers and investors. The statement will serve three primary purposes: - Legally Inform: It should provide necessary legal information pertaining to the product in a clear and concise manner. - Highlight Product Attributes: Clearly elucidate the features and advantages of our product in a way that is easily understandable. - Disclose Risks: Any and all risks associated with the product should be transparently presented in an upfront manner. The final product should be a digital document, for easy access and convenient dissemination. The ideal freelancer for this project should ideally have experience in technical writing, p...

...Requirements: - Bold and Colorful: The ideal logo should stand out visually, utilizing a vibrant color scheme. - Unique and Memorable: I'm seeking a design that is distinct and memorable, helping my brand to stand out in a competitive market. Additional Info: - Pink, Teal, and Gold are the colors I'd like to incorporate into the design. These hues should be utilized in a way that is impactful yet balanced. - The logo should be a visual representation of my brand, capturing its essence and communicating its values. Ideal Skills and Experience: - Proven experience with logo design, particularly with bold and colorful styles. - Strong understanding of color theory and the ability to apply it effectively in de...

...developer to resolve a syntax error and implement a script that tracks short and long highs/lows with Fibonacci levels in TradingView. The script should: Track the short high using a 100-bar lookback period. Determine the short low from the lowest low after the most recent highest high. Track the long high/low based on the selected date range. Include customizable options for line colors, widths, and visibility. Draw Fibonacci levels between long highs and lows. An error occurs with the if statement, and I need help to fix it and ensure the script works correctly without syntax issues. If you're experienced with TradingView's Pine Script and can resolve this error while maintaining the...

I need a resume writer who can effectively update and polish my resume, providing a clear, concise format and injecting relevant keywords. Ideal skills for this job: - Experience in resume writing, particularly for the technology industry. - Expertise in creating clear, concise content. - Good understanding of keyword use to optimize resume visibility. The project involves: - Crafting an engaging objective or summary statement. - Highlighting my work experience with focus on relevancy to the technology sector. - Clearly detailing my educational background and certifications. - Showcasing my skills aligned with the jobs I am targeting. With your help, my updated resume should stand out among other applicants and accurately present ...

Preparing the Financial Statement for 2023

I am seeking an artist to create a cartoon design of a gangster dog character, embodying a combination of realism and intimidation. The character should demonstrate these key features: - A relaxed, lounging pose. - A bandit mask and hat with the statement "capital remedy." - A joint in its mouth. The character should also feature these accessories: - A money bag. - A gold chain and gold pendant, with the pendant also inscribed "capital remedy." Ideal skills and experience for the job: - Experience in character design and illustration. - Ability to convey emotion and attitude through character design. - Strong sense of aesthetics and detailing in cartoon art. I'm seeking high-quality work...

As an entrepreneur with an RCM Business, I am looking for a business plan that can not only present a standard model but attract potential investors. My business plan needs to: 1. Emphasize on * Standard Business Model: Clearly articulate the traditional and consistent business operations that my RCM enterprise adopts. 2. Include Key Components * Income Statement: A detailed income statement highlighting the revenue and expenses over a specific period. * Cash Flow: A cash flow statement displaying how changes in balance sheet accounts and income affect cash. * Balance Sheet: A report that summarizes my firm's financial standing in terms of assets, liabilities, and shareholders' equity. * Revenue Brea...

I am seeking a skilled web designer to create an intuitive and engaging website (not a logo) primarily geared towards promoting the mission of an emerging charity. Besides, the website should be designed with functionalities that allow for recruitment of people who have had brain injuries and want to help improve the care others receive. Key requirements to note: - The site's main objective is to attract individuals ready to join our efforts in enhancing care. - The website needs to prominently feature our mission statement to clearly communicate our cause and attract support. Ideal Candidate: - A candidate with a strong background in website design and experience in charity web design. - Excellent in UI/UX for intuitive navigat...

Transformasikan template google sheets saya dari VLOOKUP menjadi Apps Script/VBA

As a senior executive, I'm looking for a professional CV writer who can create a compelling resume that will pass applicant tracking systems (ATS) and appeal to potential employers. Key Requirements: - Craft a CV in a Word document format that aligns with ATS requirements. - A strong understanding of the senior/executive level job market and what recruiters are looking for. - Experience in writing CVs that stand out and are engaging. - Provide suggestions and guidance on whether including a professional summary or objective statement would be beneficial for my career level. Please share your expertise and how you plan to tackle this project.

I need an attorney to create legal documents such as privacy policy, terms of use, and more if necessary for a dating app like Tinder. I am trying to launch in the US. The project is for business use, and please show me previous works working with privacy policies, terms of use, and more if you have done these before. You can benchmark documents that are doing similar service as my app (ie Tinder), but since our app has different capacities and functionalities, you might have to know how my app works to write comprehensive documents, I want this to be done ASAP.

I am seeking an accounts trainee to assist with various accounting tasks, including bookkeeping, financial statement preparation, and tax filings. - Strong Excel and TALLY functionality is a must. - The ideal candidate should also be adept at creating specific reports, i.e. profit and loss statements, balance sheets, and cash flow statements. Overall, a keen eye for detail and previous experience in accounting will be preferred.

...features such as: - Document Storage: Easy, systematic and secured storage of all contracts. - Automated Notifications: Efficiency in keeping users up-to-date on contract status. - Reporting & Analytics: Sophisticated tools for generating detailed contract reports and analytics. - Payments Tracking: Ability to track payments stemming from each contract. - Supplier Account Statement: Functionality to maintain and access supplier account statements. - Editing Contracts with Variables: Flexibility to modify contracts with various variables. The software is to be used by a team of 1-10 people, making it important to have multiple levels of access controls. Ideal freelancers should have experience in programming and software development...

I'm in search of a developer experienced in designing mobile ap... Project details: - The app should include features such as user registration and login, in-app messaging, and payment gateway integration. - The platform is intended for the general public, so it must be user-friendly and intuitive. - I'm seeking a minimalistic and clean design that is simple yet eye-catching. Skills and Experience: - Expert knowledge in Wix mobile app development - Experience in integrating a payment gateway into a mobile app - Proven track record in creating user-friendly apps - A keen eye for clean, minimalistic design Please note, my budget for this project is $3000. Only those with relevant knowledge and experience should apply. Let's...

I'm seeking help with analysing financial statements, particularly the income statement with a strong focus on revenue recognition. As a business owner, I need to deepen my understanding of my financial situation, and I believe grasping this concept will be pivotal. Key responsibilities: - Interpret and explain my income statement - Highlight critical aspects of revenue recognition - Showcase practical insights using my financial data Ideal Skills and Experience: - Excellent understanding of finance and accounting principles - Proficiency in interpreting financial statements, especially income statements - Prior experience in business financial analysis - Extensive knowledge in revenue recognition - Ability to teach and...

...Factory is a vibrant and upcoming fashion brand based in Bangalore, India. We specialize in creating trendy and hip products that celebrate individuality and embrace the unconventional. Our product range includes t-shirts, bucket hats, wall frames, and more, all designed to make a statement and ignite creativity. Role Description: We are seeking a talented and versatile Freelance Graphic Designer and Stylist to join our creative team. The ideal candidate will be responsible for designing eye-catching graphics for our products, styling and modeling during photoshoots, and bringing our brand's vision to life through innovative design concepts and visual storytelling. Responsibilities: 1. Graphic Design: ...

I'm looking for an experienced Android app developer, particularly someone who has worked on a satta matka app before. The app will require a good understanding of the game and its features. Key Requirements: - Prior experience in developing satta matka applications - Proficiency in Android app development Please only apply if you have the necessary experience and skills in this area. Looking forward to collaborating with a skilled professional.

I need a skilled web designer who...who can help mold my website. The experience and skills you bring to the table should should be available for virtual meetings before I decide upon you. - Photoshop expertise: You'll be instrumental in curating and modifying visuals that make a statement. Demonstrated experience with Photoshop is mandatory. - Profound knowledge of UI/UX design: This website is all about user experience and intuitive utility. I'm looking specifically for someone who has a significant background in UI/UX design. - Mastery of responsive design: As this website is targeted at the youth population, a fully responsive design that accommodates all device types and screen sizes is a must. With your skills and c...

...create performance events and support local artist / musicians / performers through grants. Key Responsibilities: - Utilize social media and email marketing to raise awareness for the fundraising and sponsor campaigns - Organize in-person events to engage the audience and encourage donations - Call and solicit key fundraisers - Manage donor relationships and renewals Ideal Candidate: - Previous experience in fundraising, especially for a art related non-profit organization - Expertise in social media and email marketing - Strong organizational skills for fundraising and sponsor event planning Our website: We are located in Metuchen NJ - a small but relatively affluent and vibrant community, which is beco...

As a small retail/trading bus...retail/trading business, we are in need of an experienced Chartered Accountant. The ideal professional will provide us with the necessary financial guidance and services that are necessary for our operation. This includes: -Tax planning and preparation: To rightfully navigate and implement ways to reduce the financial liabilities of our business. -Financial statement preparation: To accurately reflect our finances, aiding in better decision making. -Filing of GSTR 9 -Preparation of Project Report The perfect applicant for this job would have prior experience in retail/trading businesses under the same role, and understands the demands and challenges in this industry. Fluency in financial laws and reg...

...somebody to write an impact statement for my research in Epidemiology. After thorough investigation and study, my team and I have identified significant findings that need excellent narrating to efficiently convey its significance and potential influence within the field of health sciences. The chosen candidate should: - Have expertise in writing within the field of health sciences, especially epidemiology. - Have a good understanding of research methodology and the potential impact of research findings. - Be able to construct a compelling narrative justifying the importance, reach and impact of our epidemiological research program. - Be able to review relevant existing literature and appropriately reference them to support the narrative...

I'm in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The for...in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The formula needs to leverage advanced functions like VLOOKUP, INDEX/MATCH, and ARRAY. Key Requirements: - Advanced Excel proficiency - Expertise in VLOOKUP, INDEX/MATCH, and ARRAY functions - Experience with multiple sheets data integration - Strong problem-solving skills and attention to detail Please note that this isn't a project suited for beginners in Excel. You should have a proven track record in working with complex formulas and integrating data across different sheets. Your abilit...

I'm looking for an experienced Flutter developer to help me create a Point of Sale (POS) page compatible with various platforms such as web, iPad, Mobile, and Windows. Please be aware that there's currently no API in my existing source code. If you're unable to handle this task, I may consider hiring someone else. However, I'm interested in understanding your requirements before making a decision. Kindly note that my budget for this project is up to $120. If your pricing exceeds this limit, I kindly request you not to bid for the project. (300$ IF 1 WEEK TO FINISH THE PROJECT) ( Contact me for more details )

Financial Statements based on Excel template and Data - you product financial Statement with filled out excel based on data given We need an expert Freelancer to enter basic financials data to attached financial Projection in Excel and produce a profit loss statement based on this Excel attached and the data of company projected Revenues and expenses Simple if you have done it before You will send us back the filled out excel with sheet tabs including the Financial Planning Tab and Profit Loss. Budget is $200 - $300 +/- Very Simple just summarize and detail the data correctly any questions or data you need for this ( not given in attachments in zip ) we will give you You need to put all Hungarian Forint Curren...

I am in need of a skilled accountant to help with the preparation of my financial statements. The ideal candidate will have experience with Xero. Key requirements of the project include: - Preparation of Income Statement, Balance Sheet, and Cash Flow Statement - Proficiency with Xero accounting software Please note, the successful applicant should have a strong background in accounting, with prior experience in financial statement preparation being highly valued.

...tasks typically associated with an accountant in the finance field. Key Responsibilities: - Executing standard accounting functions such as bookkeeping, financial statement preparation, and tax returns. - Offering financial advice and insights based on analysis of financial records. - Managing financial transactions and providing timely financial reports. Ideal Candidate: - Proven experience as an accountant in the finance industry. - Strong understanding of financial principles and standards. - Proficiency in accounting software and tools. - Excellent analytical and communication skills. This role is perfect for a professional who is adept in accounting and has a keen interest in finance. The ideal freelancer will be ab...

...for IoT intrusion detection, with a core focus on network traffic monitoring. This work should be comprehensive, encompassing both theoretical foundation and practical applications of deep learning in securing an IoT network. Ideal Skills and Experience: - Deep learning methodologies - Familiarity with IoT and intrusion detection systems - Strong understanding of network traffic monitoring - Proficient in academic research and scientific writing. I have the code ready and literature review you can use this is the requirement: Abstract Introduction: Problem Statement, Solution, Objectives • Background Review and Related Work • Proposed Solution: Model / Methodology / Experimental Settings • Evaluation/...

Hello, I am an electrical and electronics engineer with a master's degree in the field and I have an idea for a patent. I am interested in examining the transition of some medical device to connect an accessory to a smartphone + building a suitable application for the accessory. And if there is indeed the possibility of building a complete prototype + a suitable application. Further details will be given to the respective freelancer after signing an NDA.

Local area la e commerce grocery mobile app promote pannanum. App install pandravanga, order pandravanga count increase pannanum. Usual marketing like SEO, SMM um venum. Athu illama creative ah innovative ah epdi increase panlam nu strategies um venum. Portfolio strong ah iruntha ithuku munnadi ipdi oru project panni nalla result kaatiruntha bid pannunga.

I am seeking a talented professional to assist me with my accounting work using TALLY ERP 9. The tasks will include data entry, bank reconciliation, and financial statement preparation. Key Responsibilities: - Data entry for up to 50 transactions per month - Bank reconciliation - Financial statement preparation The ideal candidate will have prior experience with TALLY ERP 9 and data entry. Additionally, understanding of accounting principles and GST will be highly beneficial. Accuracy, efficiency, and a strong attention to detail are crucial for success in this role.

I am seeking a talented professional to assist me with my accounting work using TALLY ERP 9. The tasks will include data entry, bank reconciliation, and financial statement preparation. Key Responsibilities: - Data entry for up to 50 transactions per month - Bank reconciliation - Financial statement preparation The ideal candidate will have prior experience with TALLY ERP 9 and data entry. Additionally, understanding of accounting principles and GST will be highly beneficial. Accuracy, efficiency, and a strong attention to detail are crucial for success in this role.

I am looking for a professional with strong data entry skills to assist in transferring text data from digital documents into an excel sheet. The successful candidate should possess: - Reliable accuracy in typing - Fast typing speed (numeric keypad advantageous) - Proficiency in Excel (VLOOKUP, SUMIFS, Pivot Tables, etc.) - Able to interpret written information swiftly - Excellent attention to detail for proofreading entered data. This task will require someone with experience in handling large volumes of data entry, with absolute prioritization on maintaining the integrity and accuracy of the inputted data. Any previous involvement in similar projects handling text data is highly desirable. Understanding of and/or a background in just managin...

A small company is in need of monthly accounting services with total 4 days of work needed, I'm seeking a skilled and experienced accountant who is proficient in various financial responsibilities. Key Requirements: - Expertise in Bookkeeping - Proficiency in Financial Statement Preparation - Experience in Tax Planning and Preparation - Handling Accounts, Finance, and Tax Related Documentation and Audits Specific Software Requirement: - Proficiency in QuickBooks is a must. Frequency: The accounting services are required on a monthly basis X 4 days of work per month (one day per week and can be on weekend). This will include maintaining my financial records, preparing financial reports, and ensuring all tax documentation ...

...process of launching a new clothing line and need a fresh, modern logo to represent my brand. Key Requirements: - Modern Design: I'm looking for a logo that embodies a modern aesthetic, in line with current trends. - Color Scheme: The logo should primarily use black, white and red, with a clean and bold look. - Creative Freedom: I'm open to suggestions regarding the symbols or icons to include in the logo. I'm seeking a designer with a young and fresh taste who can bring originality to the project. -Should have crystal, flashy work in the fonts Ideal Skills: - Prior Experience: I prefer a designer with a proven track record, particularly in the fashion industry. - Understanding of Trends: A good understanding of cu...

...process of launching a new clothing line and need a fresh, modern logo to represent my brand. Key Requirements: - Modern Design: I'm looking for a logo that embodies a modern aesthetic, in line with current trends. - Color Scheme: The logo should primarily use black, white and red, with a clean and bold look. - Creative Freedom: I'm open to suggestions regarding the symbols or icons to include in the logo. I'm seeking a designer with a young and fresh taste who can bring originality to the project. -Should have crystal, flashy work in the fonts Ideal Skills: - Prior Experience: I prefer a designer with a proven track record, particularly in the fashion industry. - Understanding of Trends: A good understanding of cu...

I'm looking for some assistance with my resume. Specifically, anyone who takes on this project would need to pay special attention to: - Objective Statement: This needs some serious fine-tuning. My current statement lacks focus, and I'm counting on you to help me create something punchy, concise, and attention-grabbing. - Work Experience: The details are all there, but it lacks in professionalism and polish. Your job will be to enhance the language, highlight my achievements, and make my experiences shine. Ideal candidates will have a strong history of resume writing. Past work in HR or recruitment would be a plus but is not a strict requirement. Knowledge of and experience with combination style resumes is a must....

...sell quickly. If you're looking to make some quick cash, this project is perfect for you. I'm seeking motivated individuals to handle the sales process for me while I focus on other tasks. Job Description: I'm looking for proactive and results-driven Shoe Sales Representatives to help me sell my inventory of replica shoes. This is a straightforward project that requires you to take full responsibility for selling the shoes on my behalf. If you're looking for a quick and easy way to make money, this is the opportunity for you. Responsibilities: -Promote and sell my limited stock of replica shoes to potential buyers. -Use your sales skills to generate leads and close sales quickly. -Provide accurate information about the shoe...

I have already prepared my Balance sheet, P&L, and Cashflow so that CPA Certified this statement. Ideal Candidate: - Must have a CPA and certified statement.

I'm on the lookout for a skilled and creative jewelry designer to help me create a new designs and edit old ones to be more current - Materials: I'd like the pieces to be crafted primarily from gold and feature gemstones. Please ensure the quality of the materials used is high. We produce in downtown Los Angeles and need only CAD - Design Style: I'm interested in a range of design styles - from minimalist to vintage to more bold, statement pieces. The ideal candidate will have a good understanding of these design styles and be able to incorporate them effectively into the pieces. Ideal skills and qualifications for this job include: - Proven experience in jewelry design, ideally with a portfolio that demonstrates...

...Illustrate Aladdin’s adventure from his optimistic viewpoint—magic, wealth, and happiness (bright colors, vibrant imagery). Right Side: Show the same scenes from the Evil Magician’s perspective—dark, grim, and focused on deceit (darker, subdued colors). Textual Content Beneath the Image (Center-Aligned): Include a concise, impactful statement like, “How you see things can change everything. Your perspective shapes your reality.” Additional Quotes: Place smaller text boxes around the poster that include quotes from each character’s perspective to emphasize how their views differ: Top-Left (Near Aladdin’s Image): “A world of possibilities opened by a simple wish.” Top-Right (Near the Evil Magician’s Ima...

...candidate will have a knack for gathering and analyzing data, attention to detail, and the ability to deliver accurate and timely reports. Strong communication skills and the capability to present findings in a clear and concise manner are essential. If you have a proven track record in delivering high-quality research, we'd love to hear from you! Requirement; 1. Filled Verification form with Sign and Stamp along with verifier details. 2. 5-6 geotagged photos in which name board of Issuing Authority is visible. 3. In-case of refusal, I need written refusal statement with Sign and Stamp along with detail of person i.e. name, designation, email and phone number. Ideal candidate should...

I'm seeking qualified expertise for dealing with auto electrical systems specific to AHS trucks. Responsibilities: • Diagnosis and repair of system problems • Installation of new components • Upgrading the existing electrical system The ideal freelancer will have extensive experience in auto electrical systems, particularly as applied to trucks. Familiarity with advanced diagnostic tools and equipment is a must-have. Please, share your similar past projects, skills, and applicable qualifications.