Find Jobs
Hire Freelancers

Create a dynamic excel file

$10-30 USD

Completed
Posted about 5 years ago

$10-30 USD

Paid on delivery
I need a Microsoft Excel file where I put in a few variables and then it searches for some values in the corresponding four other tables and gives back the result. I attached a kind of mockup file of what I need. There are four tables from which the data needs to be referenced for this to work.
Project ID: 18826626

About the project

27 proposals
Remote project
Active 5 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
Hi, I can write this function for you in less than 1 hour. you just need a lookup formula (or depend on your tables match and offset formulas), send me your excel file and I will write the formula
$10 USD in 0 day
5.0 (9 reviews)
4.0
4.0
27 freelancers are bidding on average $31 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$100 USD in 2 days
4.9 (329 reviews)
8.0
8.0
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 USD in 1 day
4.9 (343 reviews)
7.4
7.4
User Avatar
Dear client I can help you real fast and quick. Please contact me. Waiting to get a message. Roy .............................
$30 USD in 0 day
4.9 (348 reviews)
6.9
6.9
User Avatar
Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportunity to work with you on this project. Please feel free to check my reviews here (https://www.freelancer.com/u/safiqulislam67.html). Best regards, Safiqul Islam
$30 USD in 1 day
5.0 (190 reviews)
6.8
6.8
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best regards
$30 USD in 0 day
4.9 (233 reviews)
6.9
6.9
User Avatar
Greetings! Please share the tables for BMI, Fat %, Visceral Fat, Muscle. I can set up the workbook that the results are shown automatically after inputs are received from user. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi
$20 USD in 1 day
5.0 (191 reviews)
6.8
6.8
User Avatar
Hi there, If you haven't selected a freelancer for this yet, I'd love the opportunity to complete the required formulas that would automate the population of the BMI, Fat % and Muscle values based on the data tables within your file. I am thinking I will have to use a few different IF statements combined with a few different LOOKUP statements to ensure that the variables entered by the user return the proper results based on your various data tables. Perhaps I could see your file with the data tables included and then I could get started! Hopefully we can work together. Thanks either way for your consideration, Shaun
$30 USD in 1 day
5.0 (93 reviews)
6.6
6.6
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
$25 USD in 0 day
5.0 (110 reviews)
6.3
6.3
User Avatar
Hello there, I am an Excel freelancer and I did many project the same with this. I can give you userform for select or input keyword and show searching result. Please contact me and I can start working. Thank you.
$25 USD in 1 day
5.0 (150 reviews)
6.0
6.0
User Avatar
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some samples for you there. Please send me a message so we can discuss further details of your project
$40 USD in 1 day
5.0 (41 reviews)
5.6
5.6
User Avatar
Hello, I am ready to discuss project with you. Being experienced in working on several excel projects related to macro/formula/vba/functions/charts etc. Based on that i can quickly help you in getting your project done as you mentioned in the description. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Sapna Dalsaniya
$50 USD in 1 day
5.0 (45 reviews)
5.1
5.1
User Avatar
I can help you. I have rich experience in excel and VB, and I do my best to save your time and pocket. contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ......................................{Java, C#, VBA, PHP, HTML} • Web designing......................................{Wordpress} • 2D Graphic ...........................................{Photoshop, Macromedia Flash, ...} • 3D Graphic ...........................................{3dsMax, Blender, ...} • Engineering...........................................{AutoCad, Watergem, SewerCad, Flow3D, Elvis, ArcGIS, ...} • Researching .........................................{Green Energy, Solar cells, WaterManagement, ....} Services: ? Accuracy ? Customer satisfaction is my first "Priority" ? Time Commitment ? Availability Thanks,
$20 USD in 0 day
5.0 (44 reviews)
4.9
4.9
User Avatar
Hello. Below are two my recently completted Excel VBA projects. All are with positive feedback. Excel VBA smart document update - https://www.freelancer.com/projects/data-entry/vba-excel-compare-count-sort/?w=f Excel VBA document changes based on specific user behaviour - https://www.freelancer.com/projects/excel/excel-task-drop-down-menu/?w=f I am able to complete such a file for automated search today
$20 USD in 0 day
5.0 (22 reviews)
4.4
4.4
User Avatar
Hi, I am expert in MS Excel, Word, any type of Data Entry Work and Web Research. I am read your project and understood your requirement. I will make formula in excel accurately, timely and within your budget. I am also ready to give you sample work. I am only accept work if you are satisfied with sample work, because your satisfaction is more important for me. Let me know if you have any questions. Regards, Chirag
$25 USD in 1 day
5.0 (31 reviews)
3.7
3.7
User Avatar
Hi. From your declaration, its the kind of task that i have been experienced well. I have been experienced in programming including Excel macro VBA coding since 2000. During 2006-2013, i had been working as a senior developer for Financial system developed in MS Access which use VBA for coding constantly. I can develop your requested macro within few hours. Hope to hear from you back. Regards, Alta
$30 USD in 1 day
4.6 (3 reviews)
2.4
2.4
User Avatar
Hi, I have completed a sample work for you. please see the image in my portfolio: https://www.freelancer.in/u/daheriyakeshav?page=portfolio I have done it for BMI field for sample. I will do it for all the other fields after allotment. I assure you for: - Best Quality - Least Time - Lowest Price Please give me some work. Thanks.
$10 USD in 1 day
5.0 (5 reviews)
1.5
1.5
User Avatar
Dear Sir I have read your project description thoroughly. You need to show the details of BMI, Fat %, Visceral Fat, Muscle, automatically in the Excel Sheet. I have done similar kinds of work in my career. I am an experienced worker in Excel. 100% job satisfaction guarantee. Waiting for your reply. Thank you Regards David Babu.N
$25 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey there, That's an easy task..let me know what data would you like to reference back. For example, where you stated BMI as 22..I would need the levels which signify normal - high range in sheet 2..so I can reference it back to where the input stands (automated ofcourse!). Hope to hear from you soon, MJ
$25 USD in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
Dear Client, I understand you need a template where you can enter some of the variables then it looks in to referencing data and returns some associated values. My name is Ajay and I am very good excel advance features, formulas, formatting, data visualization, and data processing. VBA, Data Integration, Accuracy, Timeliness and Analytics are the the other skills I possess. I am sure of completion of the task in a few hours after understanding. Please allow me to work on this one if possible. Thanks Ajay
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Looks like something I have already done so feel free to PM me with more details Kind Regards, Michel
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of HUNGARY
Sopron, Hungary
4.1
2
Payment method verified
Member since Feb 14, 2013

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.