Find Jobs
Hire Freelancers

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

$10-30 AUD

Completed
Posted over 7 years ago

$10-30 AUD

Paid on delivery
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.
Project ID: 12129890

About the project

8 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
$29 AUD in 1 day
5.0 (13 reviews)
3.8
3.8
8 freelancers are bidding on average $32 AUD for this job
User Avatar
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
4.9 (116 reviews)
6.3
6.3
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$17 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 achieve what you want.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Melbourne, Australia
5.0
2
Member since Jul 2, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.