Peruttu

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.

Taidot: Excel, tiedonsyöttö, tietojenkäsittely, Visual Basic, PHP

Näytä lisää: 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

Tietoa työnantajasta:
( 1 arvostelu ) Smyrna, United States

Projektin tunnus: #22858364

51 freelanceria on tarjonnut keskimäärin 22$ tähän työhön

schoudhary1553

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 Lisää

$100 USD 2 päivässä
(388 arvostelua)
8.1
paris2785

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 Lisää

$20 USD 1 päivässä
(248 arvostelua)
7.5
P0L

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 1 päivässä
(343 arvostelua)
7.4
hdlong66

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

$10 USD 1 päivässä
(162 arvostelua)
6.9
sparkingboy2010

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 Lisää

$20 USD 1 päivässä
(304 arvostelua)
7.1
TonmoyRoy111

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 1 päivässä
(360 arvostelua)
6.9
amirn2011

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 Lisää

$20 USD 1 päivässä
(129 arvostelua)
6.6
SShtv

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 1 päivässä
(86 arvostelua)
6.0
nvchien94

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

$20 USD 1 päivässä
(161 arvostelua)
6.0
aubrey03

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] Lisää

$25 USD 1 päivässä
(134 arvostelua)
6.0
nbprince

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 7 päivässä
(70 arvostelua)
5.7
beltran0404

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 1 päivässä
(135 arvostelua)
5.7
satishtl

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 Lisää

$10 USD 1 päivässä
(55 arvostelua)
6.1
wkcompany

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 1 päivässä
(56 arvostelua)
4.9
umairabdillah12

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 1 päivässä
(15 arvostelua)
4.6
AnowarRatul

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

$10 USD 1 päivässä
(58 arvostelua)
4.7
writingapp

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 Lisää

$10 USD 1 päivässä
(32 arvostelua)
4.9
arash18k

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 7 päivässä
(15 arvostelua)
4.3
Prompty

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 1 päivässä
(11 arvostelua)
3.9
humayoonsheikh4u

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 1 päivässä
(12 arvostelua)
4.2