Find Jobs
Hire Freelancers

Excel INDEX / MATCH

$750-1500 USD

Closed
Posted about 6 years ago

$750-1500 USD

Paid on delivery
Spreadsheet, wit multiple worksheets. Worksheet PRec has a cell where a referenced name is entered PRec F4. Need a formula in PRec G14 that searches for the entered name in PRec F4. from another worksheet Bud, that is located in column B3:B137. Upon a match wish to retrieve the value in Worksheet Bud Column F that matches the row where the name from PRec F4 can be found to the cell in PRec G14.
Project ID: 16725187

About the project

52 proposals
Remote project
Active 6 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
52 freelancers are bidding on average $849 USD for this job
User Avatar
Hello, My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Thanks, Jay
$777 USD in 2 days
5.0 (883 reviews)
9.3
9.3
User Avatar
Dear Employer, I understand you r excel job and I will do it on most Reasonable rates. Please give me a chance. I have more than 10 years of excel experience. Thanks and Regads, Ash
$750 USD in 20 days
5.0 (281 reviews)
8.3
8.3
User Avatar
Hi, I am good at Excel formulas and vba. I have reviewed the description. Looking forward to work on the project. Please share the file. I have good command over index and match formulas. I can provide quick turnaround. -Chandra
$750 USD in 0 day
5.0 (1203 reviews)
8.4
8.4
User Avatar
Hello! My name's Paris Pallas and I'm a skilled and very experienced VBA developer. During my career, I've developed dozens of apps requiring macros to automate processes and enhance efficiency. By reading your brief I'm confident I can work with you to implement this macro. It will use VLOOKUP/INDEX/MATCH functions in an intelligent and elegant way to make this process as simple and efficient for you. It will take me a couple of days from being awarded the project. Please, let me know if you're going to need my services. I'm looking forward to hearing from you. Paris Pallas
$750 USD in 3 days
5.0 (567 reviews)
8.6
8.6
User Avatar
Dear Employer, I understand that you need help with INDEX MATCH formula on multiple spreadsheets. I have more than 5 years of experience in excel and VBA. We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We have worked on 325+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$750 USD in 2 days
4.9 (518 reviews)
8.4
8.4
User Avatar
Hello, I’m an expert in Excel formulas and I can help you right away. Please contact me to discuss..
$750 USD in 1 day
5.0 (490 reviews)
8.0
8.0
User Avatar
Hi, my name is Sevinc. I read your "Excel INDEX / MATCH" project descriptions carefully before bidding. I checked your requirements as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
$750 USD in 3 days
5.0 (299 reviews)
8.0
8.0
User Avatar
Dear Hiring Manager, You may review my profile here: https://www.freelancer.com/u/motiur03.html I am writing to apply for the position of Virtual Assistant for Excel INDEX / MATCH. I possess seven years of experience as a virtual assistant and enjoy the variety of work the job brings each day. As a freelance virtual assistant I currently provide a number of services for my clients including web search, web scrapping, Gumtree, Craiglist Advert posting, , Amazon, eBay, Shopify, WooCommerce listings, property listing, Excel template, Excel Formula document preparation maintaining files and record keeping. My knowledge of a wide variety of computer programs allows me to easily take on nearly any task I am assigned. I am a quick study and welcome challenges as well. As a detail oriented and organized professional I take pride in completing assignments on time and with accuracy. I can type 100 words per minute and possess excellent communication skills both written and verbal. I would love the opportunity to transfer these skills as your Virtual Assistant. Sincerely, motiur03
$750 USD in 7 days
4.9 (270 reviews)
7.8
7.8
User Avatar
Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Kind regards
$750 USD in 3 days
4.9 (161 reviews)
7.8
7.8
User Avatar
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
$750 USD in 3 days
5.0 (43 reviews)
7.7
7.7
User Avatar
Hello there !! We are expert in Ms tools with high proficiency in Excel and we can do the task at ease and we can deliver 100% Quality and accuracy. Please share the details and files with us so that we can discuss further Looking forward to hearing from you Thanks Brad
$750 USD in 5 days
4.7 (340 reviews)
7.7
7.7
User Avatar
Hi, You won’t select the right candidate without knowing what your project on writing an INDEX/MATCH advanced formula to search and retrieve value will look like. Fortunately, I can complete a part of your job before you award the project. I can tell you about how highly experienced and multi-talented I am. But I’m sure you need more than that. In less than 24 hrs, I will complete a sample part of the job before you award the project so you can be sure you’ve entrusted your job in the best hands. No commitments required! Hope to hear from you soon
$750 USD in 5 days
4.9 (69 reviews)
6.9
6.9
User Avatar
Hello? How are you? I have good skills in this fields. So i can help you with it. I will never disapppoint you Hope to work with you. Thanks.
$1,250 USD in 1 day
4.8 (91 reviews)
6.7
6.7
User Avatar
Hi there, I have over 15 years of corporate experience working in Excel creating advanced automated dashboards, reports and calculators which included complex algorithms using Excel formulas. These formulas included many different types of lookup based functions including VLOOKUP, INDEX, MATCH and so on which I think would serve me well in this collaboration! Perhaps I could take a look at your existing file and we could go from there? Also - I noticed your budget range is quite high - I would be able to code in your required formula(s) for much less than $750... it's just the system doesn't let me bid less than your lowest number in the range. Anyhow - hopefully we can chat and make a deal and I can complete this for you. Thanks either way and best of luck, Shaun
$750 USD in 2 days
5.0 (96 reviews)
6.7
6.7
User Avatar
Greetings, I'm ready to work on excel index match spreadsheet project. Relevant Skills Excel, VBA Milestones 466 USD - project requirements done and delivered 466 USD - last milestone after full checking and testing I can achieve the results that you are asking for.
$933 USD in 17 days
5.0 (116 reviews)
6.6
6.6
User Avatar
PhD in computer science having seven years of experience in Excel development.
$750 USD in 1 day
4.8 (86 reviews)
6.4
6.4
User Avatar
Hello, Do you have a sample of Excel file to work on it? My suggestion is writing a program in C# to take control of Excel file and do any thing with more flexibility and speed. Mehrzad
$750 USD in 4 days
5.0 (37 reviews)
5.6
5.6
User Avatar
Hi!, I would love to solve this Excel challenge. As you can see in my reviews, we have a great expertise doing Excel VBA. I'm willing to solve it, without beign awarded, so you dont have to asume any risks, I'll do it, I'll show it to you, then you can award. I'll be happy to start right now Thanks! Felice
$888 USD in 3 days
5.0 (11 reviews)
5.7
5.7
User Avatar
Hi, I have over five years experience in using Excel at an advanced level (formulas, array formulas, pivot table, macros, automatic calculation sheets) as an Industrial Engineer at Michelin. I am always keen to improve my work quality and productivity and I made complex Excel sheets to automate my tasks. You can find in my portfolio a file with an automatic timekeeping sheet where I used index/match combination with multiple criteria. I will be pleased to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
$780 USD in 5 days
5.0 (23 reviews)
5.7
5.7
User Avatar
I think you have placed your budget too high for this project as it sounds like you just need a VLOOKUP (or possibly a combination of a MATCH and OFFSET), could you upload the workbook at all for review as this might make the task a little clearer? I am a business analyst with over 15 years professional experience building complex solutions with Excel, VBA (macros), Access, and SQL Server. I have expert level Excel skills and an out-of-the-box problem solving approach. I would love to chat further about your formula requirements!
$750 USD in 0 day
5.0 (32 reviews)
5.4
5.4

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Apr 17, 2018

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.