Vlookup confusing punët
My website is in Wordprss My theme is Esperto I need final touches to make it ready. - I translated most of the things to Arabic, but some of them I couldn’t. - the payment page is confusing, I want to make it easier and more professional.
Please read carefully, and only bid the FINAL amount. Dont bid if you change it later. I have a calculator And I need to make changes: 1st change: Check excel for calculation. On the right part of excel shows...And put “Zip Code” with a box for people to fill in. The numbers to be filled should have this format: 00000-000 (8 numbers and a – or it wont work). 3-- If possible, after person fills in zip code, it will show the state/region and the city. Formula on the excel for this is: State: =VLOOKUP(F3, 'Tabela Airlink'!C6:K59, 8) City: =VLOOKUP(F3, 'Tabela Airlink'!C6:K59, 9) NOTE: For change #1 has a formula that requires to look at a chart that is included in the excel. Excel formula of that is =IF(F3=0,0, VLOOKUP(F3, 'T...
Hello. I have a excel spreadsheet that links up to my suppliers products on a live feed. and we are using the vlookup formula to pull stock levels, and prices and more. we need this to automatically update every few minutes and we need to be emailed if certain numbers change. let me know if you need more info. Extra what we want done: We preferably would like to log to our site, such as and be able to run the script there and view everything from there. The login can be very basic in its visual looks, as only staff members will have access and we. We would like to download the spreadsheet add products and then upload it again and let the script run and update us via email if numbers change. we will need to incorporate an API from our selling platforms , they give
have two columns that i want to exclude one from the other
Hello to all my talented folks ! I sell a decoration bundle based on a style called "SYNTHWAVE" , please do a quick search on google images to see the style I am aiming for. That decoration bundle will include the following items: Main product -A 12" x 18" poster Main product -A 1.5 meters remote controlled USB LED strip Item 1 -A Retro gaming bundle Item 2-A Synthwave music bundle I...the main products You can google "USB LED STRIP" the one I am selling has a remote controllers, here`s a couple fitting images: Feel free to ask any question on the clarification board! Feel free to ask for any extra design material Please be creative and keep in mind that it has to look eye cathing but not confusing
...!” 3. I wish to create some kind of incongruity in the viewer’s mind, make them feel like there is something about this image that doesn’t quite make sense… i.e. IT could hint something sexual (but not explicit) or weird or scary that maybe their subconscious mind notices but their conscious mind convinced maybe they’re just reading into too much (plausible deniability) …with the purpose of confusing them or making them feel even more curious about the image! 4. Make it feel there is some story behind the image…like it’s hinting at a story without revealing too much of the whole story. 5. Sometimes I like including u highlight – possibly using arrows, something circled or highlight with color or some other highlighting m...
I have a wordpress theme installed - Eventum - that I now want to personalize how I want it to look and work. It's too confusing for me, so I want someone to work with me to get it how I want it. Here's my site - Here's the demo - So as ONE example, I want to make my top menu like the demo - one row across the top. A lot of little things like that. I want all the events listed on the home page. I want to make sure the maps work (my API doesn't seem to work). I want visitors to be able to submit, then I approve. Get rid of fees. So there are a LOT of things like that that I just don't want to spend the time to figure out, but I WILL spend time with you to figure it out and tell you exactly what I want. And you'll
Please view that sheet, the Sales and Payments tabs are entered manually.. The Summary tab is calculated automatically, when you select a name from cell A2, the rest of the information should be calculated automatically..
Creating one master excel spreadsheet from various different excel and pdf documents. Adding prices with vlookup. Around 10 working hours every month.
... 3. I wish to create some kind of incongruity in the viewer’s mind, make them feel like there is something about this image that doesn’t quite make sense… i.e. IT could hint something sexual (but not explicit) or weird or scary that maybe their subconscious mind notices but their conscious mind convinced maybe they’re just reading into too much (plausible deniability) …with the purpose of confusing them or making them feel even more curious about the image! 4. Make it feel there is some story behind the image…like it’s hinting at a story without revealing too much of the whole story. 5. Sometimes I like including u highlight – possibly using arrows, something circled or highlight with color or some other highlighting m...
I am looking to improve a current website of mine that is already up and running I have done really well so far but I want to take it to the next level with a lot of ideas I don't know how set up here is my current website My website is a gaming website based on ps4 with the game fifa 19 its a football game where someone manage...ip ban users so they don't come back and track users who have banned accounts on there ip and a forum for people to post trials for teams or players looking for teams general chat and to have graphic designs that people can set up a store and sell that is most of the things I want the improvements of my current site to have I will answer any questions anyone has because I do understand how confusing this is to people who are not involved in i...
this is a simple case study for school work and I am having issues using vlookup and pivot tables to solve and organizing the KPIS.
I have 1 year experience of excel work. I know that vlookup and h lookup. etc
We need a TEXT ONLY (does not need graphics) Power Point slides created from this article: The slides should be designed to emphasize the value of Social Security as describ...created from this article: The slides should be designed to emphasize the value of Social Security as described in the article. If you read the article carefully this will make sense. The article is complex. Your goal is to explain it with slides! Please do not bid if the article is too confusing for you to breakdown into slides. Please make sure to indicate in your bid that you do understand the article!
I need help fixing a Vlookup that references a folder i don't have access to, but there is a worksheet with the options. See file - column H and K need fixing based on Matrix in worksheet titles ' Description'
I am a fitness professional and I’m looking for more audience in traffic and to be able to set up outdoor classes or classes in halls & also 1 2 1 training sessions for personal training , stroke rehab , strength and conditioning coach for one-to-one athletes or groups or teams in sports . I am struggling with all the social media marketing ,stuff jus...rehab , strength and conditioning coach for one-to-one athletes or groups or teams in sports . I am struggling with all the social media marketing ,stuff just been on a strength and success with Brendan Chaplin and how to push my business forward but when it comes to the techie stuff I’m totally lost I’m trying to start email marketing with Mailchimp but trying to get that even started it’s confusing and...
i am a purchaser for a company, i want to make my work more comfortable and fresh now i want to find some one that know about excel's useful build-in function such as VLOOKUP, LOOKUP, INDEX/MATCH and more to build me a purchase order form with drop down menu on item products code cell with the item picture also, for more detail you can contact me !
We need an excel expert with deep knowledge in macros, pivos, vlookup
Place buy stop/sell stop orders at chosen psych levels if price closes at N day High or Low. Ability to select between .00, .10, .20, .25, .50 psych/grid levels. So if .00 selected then grid is set up at every 100 pips (1.3000, 1.3100, 1.3200), if .10 then every 10 pips (1.3010, 1.3020, 1....selected then grid is set up at every 100 pips (1.3000, 1.3100, 1.3200), if .10 then every 10 pips (1.3010, 1.3020, 1.3030), and so on. If at high/low and price is coming down or up from one psych level to another then place sell or buy. Single entry and double entry option. Breakeven function. Adjustable take profit for each order. Ability to choose size of grid. Hope my explanation is not confusing but it's pretty simple and will clarify further if interested in project. Thanks for your...
Hey, i am looking for a game developer who can help me complete one of my project. so basicall, the project is abut designing a educational game on web development. it will cover 3 major topics ( levels as in game sense ) i.e html , css , bootstrap. It must include several mini-games like quizes etc .this may look a bit confusing to you so there's a ppt in the attachment which has an overview and also has some very important screenshots of the design of the game. So let me know if you are up for it.
I do have an excel question if you do not mind helping me, it is for my work. I am working on a spreadsheet where I have to take for example: If cell G:G="3020" & cell J:J="Credit" then copy the number in Cell K into another worksheet or workbook. I tried doing a IFANDTHEN formula but could not get it to work, I also tried a combination of formulas and a vlookup but that also did not work. Can you help me with this? I have attached a small spreadsheet as an example but the one I am working on is much larger.
We are Looking for someone expert in qualify for this project I will send some of the selected freelancers an excel test to complete in a given time. You can expect in test expect these functions ROUND, SUM, MIN, MAX, AVERAGE, VLOOKUP, Custom Sort (multiple levels). CONCATENATE, IF, Conditional formatting,
The title might be a bit confusing, but here is the whole project. Basic Requirements - + Must communicate through discord () + A clean schedule to focus on the project My company is looking to create a business tool in which fiber/internet providers in different areas can pay a fee to be shown on our consumer comparison tool. Fiber companies will often have Google Earth files that have their fiber routes outlined. The goal is for a person/business will input their address and see what fiber providers are available within their area, compare their prices, and recommend the best or sponsor companies who pay for it (after approval first for being a good provider. We're here to provide accurate results without harming users with a bad service.) A backend, while not nec...
I have a sheet in excel that I use to quote work need some vlookup and VBA to insert data. this worksheet is very simple I have a vlookup for accounting number want product instead. I want a VBA box to insert all data instead of in cells.
Hi, I am new to this and if it offends anyone I apologize. I am looking for 1 person to offer support on any centos issues I might have from day to day. (other skills will also be an advantage) I have used your ticketing system and have dealt with 4 people. It gets confusing when I have to deal with many people. What I need is one person to deal with and will pay an hourly rate for your services. We will end up building a strategic partnership, which will continue into the future as the business grows. You will be joining a group of people who are excited about growing and expanding our business. Company shares will be made available after 2 years. Is anybody interested out there?
I need you to develop some software for me. I would like this software to be developed which can automate work allocation and can specifically change time format, date formats and incorporate additional information against a specific value I have a data in Excel sheet, out of which I need to allocate work to my team on day to day basis with specific change in formats, Presently I do it with Vlookup, but I am looking for more feasible and time saving solution. I would like to have email button incorporated so as I can for ward the work allocation to the individual directly
I need to redesign the logo for the Southside Rock'n'Roll Club to be less confusing and work well in online products as well as for print (leaflets banners, etc.) and on merchandise (t-shirts, caps, mugs, etc.) I have attached pdf and jpg versions below - these are the only formats we have. We need the logo reproduced in formats appropriate for a variety of uses as outlined above. We wish to retain the basic design but clean up some of the symbols. It must still have a retro 1950s feel. Visit our website if you need to see more of what we do.
Hey Basil, My girlfriend and I are working on a Russian-language 3D animated short called 'Post-S...also been taken over the years, condemned to seeing their rightful owners in the kindergarten each day, but unable to go back home. Together, the toys plot to escape. But as they devise a plan to return to their homes, political events and remnants of Soviet bureaucratic practices threaten to stop them. We want the film to be funny, but also to provide a serious meditation on the dramatic and confusing transformation that Russian society underwent after the collapse of the Soviet Union. Would you be interested in working with us on this? If yes, we would be happy to send you our initial drawings and the script. We would also love to chat with you on Skype if possible. All t...
Post-Soviet Toy Story is an animated short in the tradition of the Pixar classic Toy Story, but drawing heavily on Soviet animation. We are looking for artists to help bring our vision to life. A toy wakes in a kindergarten to find that she had been stolen from her owner by the kindergarten teachers. She ...Other toys had also been taken over the years, condemned to seeing their rightful owners in the kindergarten each day, but unable to go back home. Together, the toys plot to escape. But as they devise a plan to return to their homes, political events and remnants of Soviet bureaucratic practices threaten to jeopardise their endeavour. Post-Soviet Toy Story is a meditation on the dramatic and confusing transformation that Russian society underwent after the collapse of the Sov...
...Priority (4.) On mobile web browser there is css layer overlapping on top of a bottom and blocking it from being pressed. That needs to be fixed. Task Priority (5.) On the main jQuery modal window - only show controls that are needed at the moment. remove any controls on the model window that are not being immediately used at the moment. (this is to unclutter the area and to make it less confusing) Task Priority (6.) Database/SQL task to add flag to user record. Add "Don't show this again" option on a message window. Task Priority (7.) New Window button - When the main Modal Window is opened, make the "New Windows" button disabled (make it look really disabled(almost transparent), not just change color) and when the Modal Window is c...
Hi , I need someone to help me with SSIS package build and deployment by automating the current manual deployment. Our team is using VSTS for build and deployment of the SSIS package on to server. But we came to know that VSTS doesn't support SSIS package build . Need someone who had experiance with powershell scripting as well. I have seen lot of solutions online but confusing.
I have a spreadsheet with part numbers and costs stored in it. I need to be able to paste daily sales data into a new sheet (sales) on the spreadsheet and then run a macro that will go through each row and enter the cost price for the part sold from the other sheet (costs). I need the cells to contain actual data and not a formula, that is why I want to use a macro. If the part on the sales sheet cannot be found in the costs sheet then the price should be set to 999. The macro needs to have the ability to work with varying number of rows in the sales and costs sheet.
We're looking for an expert in Google Sheet/Excel formulas with knowledge of functions and vlookup that can build a formula allowing to speed up the work on 2 separate sheets.
Simple Excel Question. I just need to do a VLookup or whatever method formula created to take on set of data, listing my quantity and part number. And check it against another set of data - where part number is listed with my cost. Return my cost to the numbers that I stock. So in the example attached with a sample of numbers: In column D I want a formula that will return $19.72 to D6 (Because it looked up everything to match in column E and B, and returned the price from columng G) The 119211 GEAR Would return 437 in column D. Not every number in column B will match up with column E, which is fine.
i need android app, its a simple project. - Includes Live Radio, Mp3 player, PDF viewer, google virtual tour. - Audio Player (Mp3 and live stream radio) will be work as single player (e.g: if you use any play music app. if confusing, discuss with me about that.) - Notification player needed. - Admob banner bottom, interstitial ad will be applied. - One signal SDK needed. - Splash screen needed. Assets will be provided. you only create app. I need it bug free and in small size. Screenshot included, make your final bids, no change after that, all requirement is same as on screenshot.
Overview: I started working with another freelancer to do my business cards but after she got the initial design right we ran into communication problems in getting some corrections made both in terms of final color and text. I have pngs and an Illustrator .ai file to work with. This will get confusing - I already know this - good communication will be important. This will take going back/forth several times to get the colors and contrast right. Back and forth includes me taking the cards to a local printer - and waiting for the printer to get me a printed sample. I'd expect the project to take 2 1/2 to 3 weeks to complete for this reason - even though the real work may only take a few hours. History - the png and pdf (cmyk) which look pretty good on the computer screen don...
I need to import about 7000 lines of data into a larger spreadsheet from a few new sheets. I have a few (2-6) ...that has OLD data. We need to move any of the unique NEW lines over to the OLD master sheet but avoid bringing over any duplicates that are already in the OLD sheet. Basically, we are updating our yearly inventory and need to make sure we are only bring in the rows of data we need and NOT duplicate data that we do not. Looking for someone who is an Excel EXPERT and VERY experienced with using vlookup fuction of Excel. Except about an hour or so discussion ensuring the data is being handled properly. The job is quite simple but very important that it is accurate so we will have to double check everything afterwards. Please specify level of Excel expertise when biddin...
I need to import about 7000 lines of data into a larger spreadsheet from a few new sheets. I have a few (2-6) ...that has OLD data. We need to move any of the unique NEW lines over to the OLD master sheet but avoid bringing over any duplicates that are already in the OLD sheet. Basically, we are updating our yearly inventory and need to make sure we are only bring in the rows of data we need and NOT duplicate data that we do not. Looking for someone who is an Excel EXPERT and VERY experienced with using vlookup fuction of Excel. Except about an hour or so discussion ensuring the data is being handled properly. The job is quite simple but very important that it is accurate so we will have to double check everything afterwards. Please specify level of Excel expertise when biddin...
Hi there, I'm an author looking for someone to help with designing a new name logo (Elda M. Lopez) for my soon-to-be revamped website. It will take the place of the existing example name in the header (please see link: h...silver), and a circular written scroll with a possible grey inkblot (see attached files, original photo had pen pointed downward, I rotated photo. I'd like the pen nib upward). I've also attached a very rough rendering of a possible outcome. - FYI, overall color for the website will be dark grey, light grey, black and red (see attached book cover photo). I think that's it. I hope this isn't too confusing! This seems like a reasonably simple project, but then again, I'm not a pro. I'm open to suggestions/questions and I look for...
We need a TEXT ONLY (does not need graphics) Power Point slides created from this article: The slides should be designed to emphasize the value of Social Security as described in...-benefits-as-an-asset-on-the-household-balance-sheet/ The slides should be designed to emphasize the value of Social Security as described in the article. If you read the article carefully this will make sense. The article is complex. Your goal is to explain it with slides! It needs to be make into an easy-to-understand series of simple slides! Please do not bid if the article is too confusing for you to breakdown into slides. Please make sure to indicate in your bid that you do understand the article!
We need a small project completing.... i believe it involves "VLOOKUP" and will simply copy data from one spreadsheet in to another. Spreadsheet 1 will reference a customer code. We need to look up the customer code on Spreadsheet 2 and copy certain columns (address/client name etc) from Spreadsheet 2 and put in to Spreadsheet 1.
I need to turn an excel spreadsheet with vlookup features and some additional calculations into a php online calculator. will require 10 user UI inputs then will run and generate a one page pdf output.
Need someone to create a custom NBA 2K game CYBER FACE scan for me. I would like a celebrity of my choosing to be cyber faced into the game. I was told this process is somewhat confusing so if you can complete this job contact me with your price.
There are several Wordpress calendar and events plugins but none suit my needs. I need a plugin that allows to create events (for a cinema) with multiple screenings and then list it as a list of events. Good example is one other cinema's website which is a good one but on different coding language. screenings will be listed chronologically (like at the link). I would like a plugin that let's me create events to wordpress like making a post. But it should let me choose dates and times and then create different url-s for each SCREENING. For example: And if I edit the event then the information on all screenings will change. Maybe a bit confusing description but let me know if it is doable!
...”” and save it in OpenDocument format. B) Make the conditional formatting for the column ”WorkHours” such that: • values greater than 50 are printed in bold and have yellow background color; • values between 44 and 50 have blue font color. C) Fill in the column ”ExtraBonus” accordingly to the table in the sheet ”Bonus” taking into account values in the column ”Bonus” (use the function vlookup). D) Add the new sheet named ”Out1” and copy there the output of the data filter due to the following rules: • all men with no children or all women with the salary exceeding $6500. E) Create pivot table to present maximum salary corresponding to the retention probability and number of children with the po...
Hi, I need an excel tool My project looks very simple for someone who know excell. I have many files of lists of clients extracted from 6-7systems, and for each clients I have an ID number. I need to do an Automatic research from thoses 6-7 systems, and excell give the result when the ID refer to a client in the 6-7 Systems. So it will be especially Pivot Table, and Vlookup. ( The best would be a VBA) thanks you very much. regards,
I would like someone to build me a macro in VBA that I can upload into Excel as default and use for formatting models. So when I open Excel each time, this macro will be running. The functions of this macro are purely for changing colours and formats so it should be very easy for someone who can pull together macros. I have attached a list of ...macro in VBA that I can upload into Excel as default and use for formatting models. So when I open Excel each time, this macro will be running. The functions of this macro are purely for changing colours and formats so it should be very easy for someone who can pull together macros. I have attached a list of the operations I would like by hitting keystrokes. Please let me know if this is confusing or you need me to explain furthe...
Customers are having errors completing a purchase on my website when they select 'Afterpay' as payment. After they click 'PLACE ORDER NOW' button which is supposed to redirect them to afterpay website they get this error message: Afterpay API Gateway Error. I have attached full error below with my URL blocked out. Not all customers have this issue, only some which makes it very confusing. Would love this fixed ASAP Thank you.
I want to do a VLOOKUP to move data from one spreadsheet to another. I can do VLOOKUPs but this has an element that I do not know the VLOOKUP script for. The spreadsheet 'ABR template' contains some data with Suburbs in Australia and telephone prefixes. The spreadsheet 'Postcodes by Suburb' contains some data with Suburbs in Australia and Postcodes. I need to combine these so that I have the suburbs and the postcodes in the same file with the telephone prefixes. The important field in file 'ABR template' that I want to match is column D (Suburb). If the suburb in column A of the file 'Postcode by Suburb' is contained within column D of the other spreadsheet then I need the postcode alongside that suburb in file 'Postcode by Su...
