Do some Excel Work - Experts In Formula Creation - INDIRECT/VLOOKUP/DEPENDANT DATA

Closed

Description

The attached spreadsheet needs some drop down menu's created and these will be dependant on certain lists in another page on the overall spreadsheet.

For Example:

Cell: Products B7

requires a drop down selection from a list created from,

Page: Components A4:57 titled as a list

Called: Ingredients.

Now once this drop down lost appears from a previous process of a Data Validation carried out to create the list called: ingredients, then.. in the sheet: Products in [the columns] E7 and downwards, the cost of that ingredient in the dish [reference Components E15] should automatically come up.

So ideally speaking, once the user selects an Ingredient in the Columns of Sheet Products, Row B downwards, being the components of a product, which have been created as drop down selections of a list, from a Data>>Validation>>Settings>>Allow>>List>>Source >>[enter list name] Ingredients..

The cost of that ingredient referenced from the components page should automatically come up once the ingredient has been chosen to add into the components for a product.

What is required is to simply just outline the process to do this, which then we can use that technique to do this to the rest of the fields required in the spreadsheet. You would have to write down the process to do this, in order to complete the job. You do not have to go trough and do the whole sheet.

Skills: Data Entry, Data Processing, Excel

See more: Data entry, spreadsheet,Excel, work from home, https www freelancer com projects data entry some excel work 10628254 utm_campaign latest_project_contest, excel office experts in mumbai, data entry and excel work, offline data entry excel work, excel data creation, formula excel work hour, demo data entry excel work, excel work home data entry, data entry excel work home, data excel work home, outsourcing data excel work, excel data creation graph, excel data enrty operator can work excel, data entry excel work coimbatore, macros work excel internet, macro dont work excel 2000, freelance work excel vba, track work excel, macros written excel 2000 work excel 2007, contract work excel access, excel 2000 macros work excel 2007, article submission work excel, show project work excel, work excel file

Project ID: #12129890

Awarded to:

$29 AUD in 1 day
(13 Reviews)
3.8

8 freelancers are bidding on average $32 for this job

$100 AUD in 1 day
(248 Reviews)
7.6
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 AUD in 1 day
(116 Reviews)
6.3
josephmoeller

I am a native English speaker with a master of science in information science. I have a lot of experience with excel and programming in VBA in Excel. I will create a simple how-to guide with screenshots on how to a More

$25 AUD in 1 day
(0 Reviews)
0.0
ovi1703

A proposal has not yet been provided

$17 AUD in 1 day
(0 Reviews)
0.0
AyazAkhlaq

hello sir, i am seen your attachment and understand your project . i am start your project right now . i am new freelancer but not new in this field contact me to start your project right now thanks

$22 AUD in 1 day
(0 Reviews)
0.0
$25 AUD in 1 day
(0 Reviews)
0.0
$10 AUD in 1 day
(0 Reviews)
0.0