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.
51 freelanceria on tarjonnut keskimäärin 22$ tähän työhön
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
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.
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.
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.
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 Only ----- I can generate your formula within 09 Minutes ------ Excel VBA Macro Coding, Formula Generation and Automation Expert with 5* rattings.
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
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