Find Jobs
Hire Freelancers

Excel Formula

$10-30 USD

Annulé
Publié il y a plus de 4 ans

$10-30 USD

Payé lors de la livraison
Need an excel formula for a spreadsheet. Should take less than 10 minutes. Actual spreadsheets attached. This is a database of products for an ecommerce site in Sheet 1. Sheet 2 is a database of products from the manufacturer with quantities in stock. eCommerce site needs to decide whether to make the items visible or not, based on inventory. Reference "SKU" in Sheet 1. Search for a match for this value in "ITEM ID" in Sheet 2. Once a match is found, reference the inventory quantity "AVAIL" for that matching item. If <1, return value of "N" in the "VISIBLE" column in Sheet 1. If >=1, return value of "Y" in the "VISIBLE" column in Sheet 1. If no match is found, return value of "XXXXX" in "VISIBLE" column in Sheet 1. Repeat process for all entries in "SKU" column in Sheet 1.
N° de projet : 22858364

Concernant le projet

50 propositions
Projet à distance
Actif à il y a 4 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
50 freelances proposent en moyenne $22 USD pour ce travail
Avatar de l'utilisateur
Hello, I’m an Excel expert and I would like to help you with your formula. Please check my profile and contact me to discuss further details. Regards.
$25 USD en 1 jour
5,0 (490 commentaires)
8,0
8,0
Avatar de l'utilisateur
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel formula to return values from a second sheet based on some conditions. It's already ready in my mind! I will charge you $20* and can deliver within 10 mins (I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 340 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas
$20 USD en 1 jour
4,9 (409 commentaires)
8,2
8,2
Avatar de l'utilisateur
Hi, I am ready to start right away. I'm an expert in Data Entry. I have reviewed your job description as well and very confident to handle this project perfectly. I understood your all requirements. I have done many projects like this. Can you send me a message? Then we can discuss the details. Regards, Noor
$20 USD en 1 jour
4,9 (370 commentaires)
7,3
7,3
Avatar de l'utilisateur
Dear client I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. I understand your requirements. I can make that happen. Please contact me. Roy
$20 USD en 1 jour
4,9 (483 commentaires)
7,4
7,4
Avatar de l'utilisateur
Hello, I have written an excel formula already. Please drop a PM if you’re interested. Best regards, Hoang
$10 USD en 1 jour
5,0 (175 commentaires)
7,0
7,0
Avatar de l'utilisateur
$ 10 Only ----- I can generate your formula within 09 Minutes ------ Excel VBA Macro Coding, Formula Generation and Automation Expert with 5* rattings.
$10 USD en 1 jour
5,0 (346 commentaires)
6,6
6,6
Avatar de l'utilisateur
Hi, I am ready for your Excel Formula project. I can complete it now. I have around 9 years of working experience in Freelancer projects. Already I have completed over 196 project in freelancer, especially in data entry, web research, Virtual Assistant, Other Admin & also calling tasks. As per your project requirement I am sure I can do your task successfully. Your work will be in safe hand, as once I take the responsibility, it will be completed within the given time period. Please message me for further discussion. Waiting for your response. Thanking You. Regards Amir
$20 USD en 1 jour
4,9 (170 commentaires)
6,8
6,8
Avatar de l'utilisateur
Please contact. I am an Excel expert and can set formula for you within 5 mins. Thank you.
$20 USD en 1 jour
5,0 (234 commentaires)
6,6
6,6
Avatar de l'utilisateur
Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Server, MySQL, SQLite, PostgreSQL, Firebird Write Automation apps including: * Automation Desktop apps. Some examples: Automation Playing Games, Automation Start/Stop/Click 3rd party apps * Automation Web apps. Some examples: Automation Web Scraping apps, Automation Web Crawling apps * Automation Data Processing apps: Automation formatting data to a specified template * Automation Data, Document Converting apps * Automation Macro, VBA for all apps in MS Office (Excel, Word, Outlook), OpenOffice, GoogleSheet * Automation Installers/Setups * Convert your Manual tasks to Automation solutions Write Web Service, Web API, Desktop API apps. Some examples: Google API, Bing API, Facebook API, MS API Fix/Solve any errors in your OS, apps
$10 USD en 1 jour
4,9 (162 commentaires)
6,4
6,4
Avatar de l'utilisateur
Hello, Your task is clear to me and I am ready to execute the project for 25 USD for 1 day. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA.
$25 USD en 1 jour
4,9 (116 commentaires)
6,4
6,4
Avatar de l'utilisateur
Hello, My name is Luis and I can assist you with your Excel formula. Please contact me by chat then we could discuss further details! Luis Romero
$20 USD en 1 jour
5,0 (183 commentaires)
6,1
6,1
Avatar de l'utilisateur
HI, Have done this based on the SKU stocks available making it visitble Y N or XXXXX. FInd the sample data below. 17234441 !ID:28474140 Y ALABAMA CRIMSON TIDE 3 Pack Contour Golf Head Covers 44.99 49.99 22.5 Y 20194 17234442 !ID:28474141 Y ALABAMA CRIMSON TIDE 3 Pack Golf Chip Ball Markers 14.99 15.99 7.5 N 20188 17234465 !ID:28474178 Y ALABAMA CRIMSON TIDE Blade Golf Putter Cover 14.99 19.99 7.5 N 20101 17234446 !ID:28474145 XXXXX ALABAMA CRIMSON TIDE Clubhouse golf Cart Bag 159.99 179.99 90 N 20162 17234448 !ID:28474147 Y ALABAMA CRIMSON TIDE Embroidered Golf Towel 17.99 19.99 8.5 N 20110 17234455 !ID:28474166 N ALABAMA CRIMSON TIDE Fairway Golf Stand Bag 179.99 199.99 105 N 20128 17234469 !ID:28474183 Y ALABAMA CRIMSON TIDE Golf Mallet Putter Cover 14.99 19.99 7.5 N 20131 17234472 !ID:28474187 Y ALABAMA CRIMSON TIDE Mascot Golf Head Cover 29.99 34.99 15 N 20113 17234470 !ID:28474184 Y ALABAMA CRIMSON TIDE Oversize Golf Umbrella 39.99 44.99 20 N 20169 17234483 !ID:28474199 XXXXX ALABAMA CRIMSON TIDE Switchfix Golf Divot Tool 14.99 17.99 7.5 N 20148 17813212 !ID:29401657 XXXXX ALABAMA CRIMSON TIDE Tour Blade Golf Putter Cover 27.99 0 15 Y
$10 USD en 1 jour
4,6 (56 commentaires)
6,2
6,2
Avatar de l'utilisateur
Hi, I can do this in excel file and apply formula to find the exact values. I have great experience in Web research, Data Entry & Web Scrapping and can do your work accurately and in time.
$20 USD en 7 jours
4,9 (86 commentaires)
6,0
6,0
Avatar de l'utilisateur
Hi there! I read your description. I can make this done in very short time! I am ready to start work right now. i can do this work easily. IF you are interested to work with me message me.
$25 USD en 1 jour
4,8 (61 commentaires)
5,2
5,2
Avatar de l'utilisateur
Hi, I can give you the solution. Put the formulae in the spreadsheet and send it back. Regards. Reuben
$15 USD en 1 jour
5,0 (23 commentaires)
5,1
5,1
Avatar de l'utilisateur
Hi There, Expert here, i have read your descriptions, i can help you to create the formulas. just for atleast 10 minutes. Please kindly chat me. thanks. Regards..
$10 USD en 1 jour
5,0 (25 commentaires)
5,1
5,1
Avatar de l'utilisateur
Hi, I written you requested formula for matching and checking the value, please send me message I could send you the file to be checked, best regards
$20 USD en 7 jours
5,0 (19 commentaires)
5,1
5,1
Avatar de l'utilisateur
Hi, I can do this formula setting in the excel sheets . Will revert the file in few hours from the time of awarding. Customer satisfaction is Primary motto
$18 USD en 1 jour
5,0 (23 commentaires)
4,6
4,6
Avatar de l'utilisateur
Hi I can deliver to you within an hour for the excel formula. Please contact me for more information. Thank you.
$10 USD en 1 jour
5,0 (11 commentaires)
4,2
4,2
Avatar de l'utilisateur
Hello!! Am very interested in ur project and I'm an expert in PDF/Word/Excel/Excel Marcos/VBA/Visual basic/Copy typing/Data Entry/Data processing and would like to help you with your project. Please ping me for further discussion.
$10 USD en 1 jour
5,0 (25 commentaires)
4,4
4,4

À propos du client

Drapeau de UNITED STATES
Smyrna, United States
5,0
1
Méthode de paiement vérifiée
Membre depuis mars 1, 2019

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.