Vlookup confusingงาน
- the site is similar to freelancer.com * - design and configure 404 page - design and enhance "success" page when resetting the password - mark notifications read once the user open the notification tab - when i click on open project the newest project will be at the end of the page which is confusing it's should be sorted form the newest until we provide more filters for experts - the admin should be able to mark an expert as recommended (if the expert has a bid) the goal is that the expert admin choose is the first one in the list - the admin can edit "Engagement Type", edit, remove or add - the admin can filter the clients by their skills, (if i wants to know the best in "WordPress", i can see a list of experts by the years (years in order)) ...
...Bell" about a young person in a kingdom who angers the king. Then magical angels appear and give everyone bells. I can finish the booklet myself, but just need some cartoon drawings to capture the reader's attention: - Here is an outline: I will add images from my sketchbook as attachments. (Note, the QR code part which I mentioned before was too confusing.) This is a story that introduces the concept of blockchain. Description of Images: (In the style of comics, "The Bell" and an image of a handbell. - child and dog walk up road in village. child has paper in right hand. Sun rising beyond mountains. - on literal soapbox, child reads pronouncements about unfair taxes. Dog sees that people are not paying attention
...four specific areas: VLookup, Index, Match, and Power Query. - Desired Learning Method: I am leaning towards learning interactively and remotely hence, the preferred medium of instruction I'd love to see is online video tutorials. High quality, clear, engaging, and interactive ones that would simplify my learning process from being a beginner to gradually becoming an expert. - Ideal Candidate: I am looking for a freelancer with substantial experience in teaching beginners Excel, and specifically has expertise in VLookup, Index, Match, and Power Query. The ideal candidate should be able to create and present the mentioned concepts in digestible video content for beginners. By the end, I expect to possess an in-depth understanding, backed by practical proficiency, o...
...experienced developer to completely redesign my current Wordpress website. Top notch UX/UI understanding and expertise in Wordpress are required. Key tasks: * Revamping the layout and design with modern, visually captivating concepts which align with our brand color scheme and enhance content readability. * Overhauling the site navigation and user experience to address problems with our current confusing menu structure, making it intuitive and user-friendly. * Updating the content and imagery throughout our website. * Significantly improving the website’s loading speed, as it's currently slow and non-responsive. Your ability to deliver a truly engaging, contemporary and fast-performing website is essential. Experience with similar transformation projects is highly ...
...enhancing the navigation and overall user experience. We like current aspects of the website, built in Wordpress, but need to update it since its about 6 years old. Key tasks include: - Redesign Website: Implement a refreshed and dynamic layout that is appealing, contemporary, and reflects our brand aesthetics. - Improve Navigation: Our Portfolio and Services Menu Galleries are currently confusing and causing issues for users. These need to be simplified and restructured for an intuitive user experience. - Enhance Portfolio and Services Menu: More than just streamlining, the galleries need to be reorganized to exhibit the diverse range of our work more effectively. Moreover, improvements to the filtering and sorting options in the galleries will be crucial for easier navig...
I need several 3D models cut. The files will be sent in FBX format and I need them returned to me in either FBX or OBJ format. Please see the attached PDF for an exact description of what I need done. The last model (ground with grass, etc) to be cut is a little more confusing and may need some back-and-forth communication.
Seeking an Excel expert to coach me on advanced skills, as I am currently at an intermediate level. I know vlookup, pivot and have an idea of formulas but have difficulty in creating formulas. Key areas to be covered include formula creation, data cleaning, and data analysis. - Excel Skills Required: - Expertise in formula creation - Proficiency in data cleaning techniques - Mastery in data analysis My idea is that we can get data from kaggle or google data search and work on it. I want to work on large data sets. I am applying for business analyst or MIS related role wherein I need to draw insights from data so I need guidance wherein I can perform these tasks by myself. I think 1 or 2 weeks of guidance would be sufficient. About 1 or 1 1/2 hour per day 4 days a ...
I need help to convert large file of products into their French translations by referring to another excel
I need help to convert large file of products into their French translations by referring to another excel
I am in need of a freelancer well-versed in advanced Excel operations. Proficiency in sophisticated formulas is vital. Although I did not specify the type of for...an example of how you can modify the existing code: excel Copy code =IF( ISERROR(INDEX('Productivity Report'!A:A, MATCH([@[XactNet Address]], 'Productivity Report'!X:X, 0))), "", IF( AND( VLOOKUP([@[XactNet Address]], 'Productivity Report'!X:AA, 4, FALSE) = [@State], [YourNewCriteria] = "YourNewCondition" ), INDEX('Productivity Report'!A:A, MATCH([@[XactNet Address]], 'Productivity Report'!X:X, 0)), IF( [YourNextCondition] = "YourNextConditionValue", [...
I am looking for assistance with an Excel formula, specifically the VLOOKUP function. Skills and experience required: - Proficiency in Excel and knowledge of VLOOKUP function - Experience working with datasets and applying formulas to them Hello guys, I need a simple excel formula to match the odds from cells H,I,J,K,L to cells AB,AC,AD,AE,AF. The names of the Teams from cells C and D needs to match exactly the same as in columns P and Q,if it doesn't matches then the cell in P or D should be blank,like this match Al-Najma ,if the name in P 28 cell is Al Najma without - character then it should be blank cell P28 (as an example). Date in cell F needs to match also with date in cell N. When all those cells match exactly the same then the odds should show up in cells AB ...
...distinct voice to my videos. I am looking for 5-10 scripts to be made. The scripts are very short, and I only need them to be 200-250 words. My niche is text message conversations, meaning I need a scriptwriter to create scripts of text convos for my videos. I am looking for scriptwriters that can create engaging, high-stake, and entertaining scritps. The genre or niche my YouTube Channel may be confusing. To help with this, I will show successful channels in my niche to you to see the type of scripts I'm looking for. - Genre: The scripts' genre is comedy - Purpose: The scripts will be used to enhance the humor and engagement level of my videos - Style: They must feel natural, as though they are real conversations happening over text messages. The ideal candidate s...
Hello Indo. We have a new job for you. Are you interested in continuing to work for us? Aleksandra, an employee of BUCHER has taken over the lead for these tasks from me. What form would you like to work in? We had the problem with the many tasks for the last caricatures, which was confusing. I would suggest working for an hourly wage. We would simply have to agree on the approximate amount of work per caricature. We look forward to hearing from you. Kind regards Christophe & Aleksandra
I am looking for a Microsoft Excel Formula Expert who can modify an existing spreadsheet within 24 hours. The specific formulas and calculations needed for this project are VLOOKUP and IF statements. According to the sheet attached Result: Input(Colum A) paragraph will be added in the sheet; From Column B to P(Output) to be Processed with generic formula. (Output) Colum Q to have Heading also to be added when concatenate (Column I to column Q) Ideal Skills and Experience: - Proficient in Microsoft Excel and experienced in using VLOOKUP and IF statements - Strong understanding of data analysis and data manipulation - Attention to detail and accuracy in formula implementation - Ability to work efficiently and meet tight deadlines If you have the skills and experience requir...
I am an author/publisher of LGBT romances. I am looking for a virtual assistant with experience working with Facebook's Ads Manager. Facebook's Ads Manager can be fairly confusing so experience working with it is important. The assignment will be to assemble 48 Facebook ads in the languages German, French, Italian and Spanish. You will need be able to pay close attention to detail and be comfortable working with text in non-English languages. Start your reply with the phrase "Facebook Ads Manager" to let me know you've read and understand the assignement.
I am an author/publisher of LGBT romances. I am looking for a virtual assistant with experience working with Facebook's Ads Manager. Facebook's Ads Manager can be fairly confusing so experience working with it is important. The assignment will be to assemble 48 Facebook ads in the languages German, French, Italian and Spanish. You will need be able to pay close attention to detail and be comfortable working with text in non-English languages. Start your reply with the phrase "Facebook Ads Manager" to let me know you've read and understand the assignement.
I am looking for a digital illustrator with experience in creating reali...angles. I will provide written descriptions of the scenes that I would like created. The scenes will have to be generated/illustrated such that the characters are consistent between images. The characters can be slightly cartoonish and don't have to match the images I provide exactly (Santa's magic may have altered them slightly) but they do have to be consistent between scenes or it will be too confusing. I will need to work through multiple drafts with the artist over the next two weeks to complete the project timely. The expected output is to have all generated illustrations back as a formatted .jpg that I can take to a photo-printing kiosk to print as if Santa or one of his elves took the phot...
I am looking for a freelancer who can create an Excel dashboard for me. The dashboard should have the following features and functionalities: - Excel Functions, including VLOOKUP, HLOOKUP, and INDEX - The primary purpose of the dashboard is to model and simulate business scenarios - The dashboard should include more than 5 worksheets or tabs Ideal skills and experience for this project would include proficiency in Excel functions, experience with creating complex Excel dashboards, and knowledge of modeling and simulation techniques.
I am looking for a freelancer who can create an Excel dashboard for me. The dashboard should have the following features and functionalities: - Excel Functions, including VLOOKUP, HLOOKUP, and INDEX - The primary purpose of the dashboard is to model and simulate business scenarios - The dashboard should include more than 5 worksheets or tabs Ideal skills and experience for this project would include proficiency in Excel functions, experience with creating complex Excel dashboards, and knowledge of modeling and simulation techniques.
...Write up your analysis. o What are the machine boundaries of the system? Does this vary from deployment to deployment? o What are the trust boundaries of the system? Are there any trust boundaries more important than others? Please make this diagram legible - I would rather you show the riskiest parts of the threat model than enumerate every possibility. As a guide, threat models get pretty confusing after about 12 primitives per diagram. If you feel your diagram must be more complex, feel free to break it up into multiple diagrams. ● Assets to Threat Model Tracing Provide a mapping from your assets in deliverable 1 to the elements in your threat model. Discuss this mapping: o Does the location in the architecture affect the p(exploit) of an asset? Why or why not? o Are th...
...Write up your analysis. o What are the machine boundaries of the system? Does this vary from deployment to deployment? o What are the trust boundaries of the system? Are there any trust boundaries more important than others? Please make this diagram legible - I would rather you show the riskiest parts of the threat model than enumerate every possibility. As a guide, threat models get pretty confusing after about 12 primitives per diagram. If you feel your diagram must be more complex, feel free to break it up into multiple diagrams. ● Assets to Threat Model Tracing Provide a mapping from your assets in deliverable 1 to the elements in your threat model. Discuss this mapping: o Does the location in the architecture affect the p(exploit) of an asset? Why or why not? o Are t...
...action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed -> simple ppt stuff 5. Maintain and update the status of various tasks with regular updates 6. Be able to present information clearly in English, not getting too bogged down by confusing details (clear communication) Expectations: 1. Self-driven and motivated to quickly achieve OUTCOMES. 2. Must be available from 6am MST to 11:30pm MST (mountain standard time) for calls - calls to connect will vary day by day. Must be very responsive via messages. 3. You will manage the workload on your own time, set your own hours outside of key meetings which ...
...action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed -> simple ppt stuff 5. Maintain and update the status of various tasks with regular updates 6. Be able to present information clearly in English, not getting too bogged down by confusing details (clear communication) Expectations: 1. Self-driven and motivated to quickly achieve OUTCOMES. 2. Must be available from 6am MST to 11:30pm MST (mountain standard time) for calls - calls to connect will vary day by day. Must be very responsive via messages. 3. You will manage the workload on your own time, set your own hours outside of key meetings which ...
...action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed -> simple ppt stuff 5. Maintain and update the status of various tasks with regular updates 6. Be able to present information clearly in English, not getting too bogged down by confusing details (clear communication) Expectations: 1. Self-driven and motivated to quickly achieve OUTCOMES. 2. Must be available from 6am MST to 11:30pm MST (mountain standard time) for calls - calls to connect will vary day by day. Must be very responsive via messages. 3. You will manage the workload on your own time, set your own hours outside of key meetings which ...
...action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed -> simple ppt stuff 5. Maintain and update the status of various tasks with regular updates 6. Be able to present information clearly in English, not getting too bogged down by confusing details (clear communication) Expectations: 1. Self-driven and motivated to quickly achieve OUTCOMES. 2. Must be available from 6am MST to 11:30pm MST (mountain standard time) for calls - calls to connect will vary day by day. Must be very responsive via messages. 3. You will manage the workload on your own time, set your own hours outside of key meetings which ...
I am looking for a freelancer who can ship my ecommerce orders on a daily basis. I want to get the data verified first in excel. You need to log in to shipping panels, export new orders data, remove wrong phone numbers, pincodes, short addresses and then match the data with a master sheet using vlookup (to remove duplicate orders) and then shipping the orders. Skills and Experience: - Advanced knowledge of Excel and data manipulation - Strong attention to detail to ensure accurate data correction - Experience in working with large datasets - Familiarity with data cleaning techniques and tools - Ability to follow specific formatting or template requirements for the corrected data
I have an excell file where i use Vlookup to a sheet, it works perfect, but some rows dont have the extra Sheet to Vlookup to. I need a statement to correct the rows when the sheet is not present
I am looking for an expert in Vlookup to help me merging two sheets. I have an existing dataset that I need to work with. The task needs to be completed within 24 hours. Skills and Experience: - Proficiency in Excel and Vlookup formulas - Experience in creating Vlookup formulas - Strong attention to detail and accuracy in data analysis
Project Overview: Create a comic that explains in detail a topic in ME 321. Your approach can cover a topic that you find confusing, you find interesting, you have observed in your daily life, or that you know well and feel like you can explain. I know we aren’t all artists here, but the goal is to have some fun building some visuals to go along with technical content. You are free to draw by hand, or use an iPad or other creative tools to generate your graphics. Your content, story and graphics, should be your own and should be done in color. The comic strip should consist of at least 20 cells to tell your story. The story can be silly, serious, completely out there but it needs to correctly apply concepts from Thermal/Fluids 1 to develop/explain/drive the story. The overall ...
Not sure why, one guy said it was ram. The AWS is even more confusing to work with, it's like I'll never find the way back. Must have knowledge of Elementor too, as that is the main plugin used.
I am looking for a...Experience Needed: - Strong proficiency in Google Sheets and familiarity with Excel formulas - Experience in troubleshooting and fixing formula issues in Google Sheets - Attention to detail and ability to identify and resolve errors in formulas - Knowledge of SUMPRODUCT and COUNTIF functions, as well as INDIRECT function Additional Information: - The specific formulas that are not working include VLOOKUP, SUMIF, and IFERROR. - There are no specific error messages, but the formulas do not provide the expected results. - The focus of this project is solely on fixing the existing formulas, no additional functionalities are required. If you have the skills and experience required to fix the formulas in my Excel file for Google Sheets, please submit your proposal. ...
PLEASE READ THE DIRECTIONS BELOW. ANY ADS THAT DON’T COMPLY WILL BE REJECTED! I need a 45" X 67" ad created. I want the ad to mirror our color layout while being extremely readable and eye catching so check out our website for ideas (). Everything below in “quotations” is what I’d like on the ad. If this is confusing see attachment, everything circled in red is what i want on the ad. ———————- I want this in the biggest lettering: “TAX TIME IS HERE!” “$10,000 Same Day Refund Advance” “+” “$100” ——————— This will be in smaller lettering: “Mention Promo Code 1+1” “813-930-0021” —&mdas...
I am looking for some help with Excel formulas and functions. I have a simple order form with 2 sheets (I believe the issue may be solved with vlookup function) Sheet 2 has a column A of product options. These options need to be linked to their values in the adjacent column B. Sheet 1 Has the list of simplified options (Column A) with drop down lists showing the corresponding options in Sheet 2. When clicking the drop down item the corresponding price needs to show in Column B & then a total of Col B at the bottom to show the total price of all options chosen.
Hi, I'm going ...offering soon, and I want a few people to test it on first. There will for sure be some grammatical errors, but don't care about them, but I am more interested in how you feel about the text in general. The total text of around 4000 words and 2 videos in a website. Read it thought, look at the 2 videos and then I want to know: 1. Do you understand the text in general? 2. Is there something that is confusing? Please specify. 3. Does it feel fishy or like a genuine offer? 4. If genuine, is interesting enough to start asking for more information? 5. Would you invest in this? (hypothetically – The offer is only for my network) 6. If you had known me in person and known that I am a decent person and entrepreneur, would this make me look bad in any way...
I am looking for a freelancer who is advanced in Excel functions, specifically VLOOKUP, HLOOKUP, INDEX, and MATCH. Tasks and Responsibilities: - Assist with applying these functions to a specific project or task (to be determined) - Provide general assistance and guidance with these functions Skills and Experience: - Advanced level of familiarity with Excel functions - Strong understanding of VLOOKUP, HLOOKUP, INDEX, and MATCH functions - Ability to provide clear explanations and guidance on how to use these functions effectively If you have experience with these functions and are confident in your ability to assist, please submit your proposal. Thank you.
...video) I need some people who understand the SMO or the SEO , like post the link to other website ,like facebook ,ins ,twitter,etc. I have no time to do this . or if you have other suggestions,I am welcome for that . ----------------------------------- This is the link to my benchmark account: @BradNolanz When I was studying it, I discovered several things that were very confusing to me 1. Every time when a YouTube short video released, its views are not very large, including the number of likes and comments. However, the videos on this account are somewhat opposite. In the first few days, there was a lot of traffic, and the subsequent traffic was relatively low (sorry, I don't know which analysis website I saw it from). I'm not sure if it did some optimization or ...
I'm looking for a freelancer to create a Vlookup and Hlookup capability from a PDF file. The purpose of this activity is to create a searchable database from the PDF file, using a specific format that I have in mind. The PDF file contains more than 20 columns and more than 500 rows of data, so the freelancer should be experienced in handling large datasets. The end result should be an easy-to-use tool that will allow me to quickly extract data from my PDF contact me if you have the necessary skillset and experience to fulfill this project.
I'm looking for an exciting and unique poster for a rock band! The poster should have a vintage/grunge style. I want displayed "Medicine Jinx" (which is the band name) up front and then having it crossed out. Under it should say "I QUIT" in RED (like paint splatter?) as if it was a single release or something. I like lots of bright...breaking off into space or something. I think the corners should be darker too. I want an (old) album cover vibe to it, with personalized original flavors. For the main text I want it in some bold, identifying text, again following the vintage style (I just love the uniqueness of it) like it was ACTUALLY MADE back then. Below I made a (terrible) example of what I'm thinking. Sorry if this is confusing... thank you though, I...
Need help with VLOOKUP formula in Excel 2016. Looking for someone who can assist me within 24 hours. Ideal skills and experience for this job include: - Proficiency in Excel 2016 - Strong understanding of VLOOKUP formula - Ability to work quickly and meet deadlines
...Excel files. Preferred Method: - There is no specific preference for the method of data merging. The freelancer can choose the most suitable approach based on their expertise and experience. Number of Excel Files: - The task involves working with 1-2 Excel files. Ideal Skills and Experience: - Proficiency in Excel and data manipulation - Strong understanding of data merging techniques like VLOOKUP and INDEX and MATCH - Attention to detail to ensure accurate column matching - Ability to handle multiple Excel files efficiently - Previous experience in data analysis and cleaning would be beneficial If you have the necessary skills and experience to complete this project, please bid and provide samples of your previous work....
...sheet that: Automatically updates prices and part numbers from and www.golfcart.com. Includes a visual representation of each part (pictures). Features a dashboard for easy navigation and a search bar for efficient data retrieval. Ideal skills and experience for this project include: Dynamic Price Update: Utilizing advanced data import and scripting functions (like IMPORTXML, VLOOKUP, and Google Apps Script in Google Sheets or Power Query and VBA in Excel), I will ensure real-time price updates from the specified websites. This will involve creating a link between the price sheet and the websites' databases to fetch and update data automatically. Integration of Part Numbers and Pictures: Each part number will be linked with its corresponding image, providing a user-friend...
I am looking for an Excel expert to assist me with two smal...1x2 AxBxC 12x89x340cm The size of the box is 53x64x10cm. Good size for shipping Requirements: Column1 return the characters found containing the * Column2 return all text in cell with the "*" replaced with x Your SKILLS & EXPERIENCE: - Proficiency in Excel and familiarity with VLOOKUP and INDEX/MATCH formulas - Experience in working with specific datasets - Ability to extract specific data using the formulas The ideal candidate will have a strong understanding of Excel functions and be able to apply the VLOOKUP and INDEX/MATCH formulas to a specific dataset in order to extract the desired data. This project requires attention to detail and the ability to accurately analyze and extract specific ...
...action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed -> simple ppt stuff 5. Maintain and update the status of various tasks with regular updates 6. Be able to present information clearly in English, not getting too bogged down by confusing details (clear communication) Expectations: 1. Self-driven and motivated to quickly achieve OUTCOMES. 2. Must be available from 6am MST to 11:30pm MST (mountain standard time) for calls - calls to connect will vary day by day. Must be very responsive via messages. 3. You will manage the workload on your own time, set your own hours outside of key meetings which ...
...action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed -> simple ppt stuff 5. Maintain and update the status of various tasks with regular updates 6. Be able to present information clearly in English, not getting too bogged down by confusing details (clear communication) Expectations: 1. Self-driven and motivated to quickly achieve OUTCOMES. 2. Must be available from 6am MST to 11:30pm MST (mountain standard time) for calls - calls to connect will vary day by day. Must be very responsive via messages. 3. You will manage the workload on your own time, set your own hours outside of key meetings which ...
I have a podcast where I talk about business and real estate related things with my guests. Originally I called this the revamp project. Now I'm renaming it to the revamp podcast - so it is less confusing and easier to find. Below you will see a link to Spotify with the old logo on there and it still says the revamp project on there. Again, the new name is The Revamp Podcast Attached is part of our logo. You can see other versions and how we try to keep The Branding similar across companies by looking at Logo should be square format just like all other podcast logos require. Final format should be all of the following: psd. pdf, jpg, and png you can also see some of our podcasts and more recent
I am looking for an Excel expert to assist me with two spec...1x2 AxBxC 12x89x340cm The size of the box is 53x64x10cm. Good size for shipping Requirements: Column1 return the characters found containing the * Column2 return all text in cell with the "*" replaced with x Your SKILLS & EXPERIENCE: - Proficiency in Excel and familiarity with VLOOKUP and INDEX/MATCH formulas - Experience in working with specific datasets - Ability to extract specific data using the formulas The ideal candidate will have a strong understanding of Excel functions and be able to apply the VLOOKUP and INDEX/MATCH formulas to a specific dataset in order to extract the desired data. This project requires attention to detail and the ability to accurately analyze and extract specific ...
...action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed -> simple ppt stuff 5. Maintain and update the status of various tasks with regular updates 6. Be able to present information clearly in English, not getting too bogged down by confusing details (clear communication) Expectations: 1. Self-driven and motivated to quickly achieve OUTCOMES. 2. Must be available from 6am MST to 11:30pm MST (mountain standard time) for calls - calls to connect will vary day by day. Must be very responsive via messages. 3. You will manage the workload on your own time, set your own hours outside of key meetings which ...
