Excel Formula

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.

Kemahiran: Excel, Pemasukan Data, Pemprosesan Data, Visual Basic, PHP

Lihat lagi: need 393 produtcts excel sheet, need someone convert excel spreadsheet web form, need programme converting excel fields protected mdb files, excel formulas tutorial, advanced excel formulas, excel formulas percentage, excel formula download, excel formulas multiply, ms excel formulas list, excel formulas pdf, excel formulas if, formula used function rate excel, need someone paper excel, need invoice system excel, much need save college excel, actual formula behind rate function excel, formula behind rate function excel, formula generate oracle report excel, mortgage formula interest capital repayment excel, formula log rank test excel

Tentang Majikan:
( 1 ulasan ) Smyrna, United States

ID Projek: #22858364

51 pekerja bebas membida secara purata $22 untuk pekerjaan ini


Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Lagi

$100 USD dalam 2 hari
(388 Ulasan)

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. I Lagi

$20 USD dalam sehari
(248 Ulasan)

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 dalam sehari
(343 Ulasan)

Hello, I have written an excel formula already. Please drop a PM if you’re interested. Best regards, Hoang

$10 USD dalam sehari
(162 Ulasan)

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 Lagi

$20 USD dalam sehari
(304 Ulasan)

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 dalam sehari
(360 Ulasan)

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 e Lagi

$20 USD dalam sehari
(129 Ulasan)

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 dalam sehari
(86 Ulasan)

Please contact. I am an Excel expert and can set formula for you within 5 mins. Thank you.

$20 USD dalam sehari
(161 Ulasan)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Lagi

$25 USD dalam sehari
(134 Ulasan)

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 dalam 7 hari
(70 Ulasan)

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 dalam sehari
(135 Ulasan)

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 1 Lagi

$10 USD dalam sehari
(55 Ulasan)

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 dalam sehari
(56 Ulasan)

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 dalam sehari
(15 Ulasan)

$ 10 Only ----- I can generate your formula within 09 Minutes ------ Excel VBA Macro Coding, Formula Generation and Automation Expert with 5* rattings.

$10 USD dalam sehari
(58 Ulasan)

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 Lagi

$10 USD dalam sehari
(32 Ulasan)

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 dalam 7 hari
(15 Ulasan)

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 dalam sehari
(11 Ulasan)

Dear Sir, I am an excel professional having hands on expertise for all types of data analysis and management. I will do your project as per your requirement. Best regards Humayoon

$35 USD dalam sehari
(12 Ulasan)